Move text from cells based on unique reference

Morning All,
Ok, so not 100% sure how to describe this but I will do my best.
I have a spreadsheet with unique values (some of which are duplicated) followed a column which lists text as below. What I want to do, if possible is say where the reference is the same, move variable1 into column variable2 etc. so rather than having my information in columns, it's displayed in rows. In the example, I would like reference 17lol 'chuckle' to remain under variable1 but move 'grin' to variable2 and 'smile' to column variable3.

I hope this makes sense! Hope someone out there can assist.
Thank you!
Prit