My Excel sheet is formatted like this.
lol.png
Name Nicknames
A Alex
A A2D2
A Bobsicle
B Ballista
B Pants
C Cory
D David
D Daniel
D Domson
To
Name Nicknames
A Alex, A2D2, Bobsicle
B Ballista, Pants
C Cory
D David, Daniel, Domson
I want to transpose and concatenate the data with similar column A.
Any help would be greatly appreciated!
Bookmarks