Formula that can merge multiple rows with the same ID into one row
I have a spreadsheet that looks like this:
Column A Column B
1234 A
1234 B
1234 C
1234 D
5678 A
6785 B
I want the Column A that has the same value to combine Column B into one row to look like this:
Column A Column B Column C Column D Column E
1234 A B C D
5678 A
6785 B
And so on for others that are duplicates...Is this prossible?
|