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.
Bookmarks