I have data in two columns that looks like Ref1 below. Column A has a value
repeated for however many times a value in column B shows up. I need unique
records in column A so that it displays like Ref2 below but I don't care how
many columns that converts to. Is there a way to do that without using VB?
I can paste special transpose for a few records, but I have thousands?

Ref1
ColA ColB
1 A
2 A
2 B
2 C
3 A
4 A
4 B
6 D
6 F
6 J

Ref2
ColA ColB ColC ColD
1 A
2 A B C
3 A
4 A B
6 D F J
Thanks in advance for the help.