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?