Appending Strings form column

Hi all,

I have a summary sheet in an excel.

I want to make a summary of a purchase order column which i text

so for example if I had the following column

Purchase Order
C-193
C-193
C-193
C-190

The summary text would be C-193,C190

is this possible without using macros?
flynnyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
You can also use a Pivot Table to create a list of PO references.

Another formula option without creating a unique list would be:

Assuming PO reference in column D like above and assuming references are sorted in order.

Against the first reference put, assumed entry in E2:

=D2

Start this formula in row of second entry, even if same PO as first entry:

=IF(D3=D2,E2,E2&","&D3)

Copy down list of data. The last entry will then be the complete list.

Thanks
Rob H
0
 
regmigrantConnect With a Mentor Commented:
Use Data, Advanced filter, unique rows to create a list of the individual items in (for example) column D

then in column E2  put
=D2

Then in E3 put

=D3 & "," & D2 & ","

If you copy this down column b you will get all of the rows added together in the final row - it will have an extra comma on the end. Copy this cell and 'paste, special, values' to a new field and you have a text version from which you can delete the extra comma
0
 
regmigrantCommented:
nice
0
All Courses

From novice to tech pro — start learning today.