Concatenate multiple cells based on specific criteria

[satkadeb]

Hello All,

I have a spreadsheet with a row of ID #'s and another row that contains text. For each unique ID I want to concatenate the related rows of text. An example is below:

ID Text
1 CC
2 CC
2 TXT
2 HC
3 TXT
3 SAT

I want to combine the text so it looks like this:

ID Text
1 CC
2 CC, TXT, HC
3 TXT, SAT

Where I am running into a problem is where there are 3 or more matching ID #'s. I do not know how to combine more than 2 rows of text for those id's that are the same.

Any help would be greatly appreciated.

[Richard Buttrey]

Hi,

With your original data in A1:B7, put

Please Login or Register  to view this content.

in C2 and copy down.

Now extract a unique list of ID numbers into D1:D3 - i.e. 1,2,3 and in E1 enter:

Please Login or Register  to view this content.

and copy down .

HTH

[satkadeb]

Thank You!! That worked perfectly!

[tani001]

this formula is good only if the ID column is sorted, can you help for the situation where the ID column is not sorted

[martindwilson]

3 year old thread! please start your own linking to this one if required