My Excel sheet is formatted like this.

transposefirst.png

Name Nicknames
A Alex
A A2D2
A Bobsicle
B Liar
B Pants
C Corry
C Corex
C Lo
C Blow
D Dex

To

Name Nicknames Nicknames Nicknames Nicknames
A Alex A2D2 Bobsicle
B Liar Pants
C Corry Corex Lo Blow
D Dex

I want to transpose the data based on the first column A then any data based on column A will be placed on the same row.

Any help would be greatly appreciated!