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?

You can use a macro as in sample workbook attached.
maybe this is not the best way to do this, as there are so many ways to do a job, and you have to improve it... (that's your job)

Attached Files

copy col to a row, next col.xlsm (21.5 KB, 180 views)

THANKS Catalin !!!!

Tried many macro's and this one worked perfectly for me after minor changes.

You're wellcome japie01 , thanks for your feedback
Cheers,