Moving data from a column to a row

Hi,

I have a list in Excel that looks like this (SAMPLE - there are 30,000 rows really);

Is anyone able to advise how I might turn this into a single row for each contact with a cell in that single row for each of their interests?

Thank you in advance for any suggestions!

Tim

AttachmentSize
excel sample.xlsx10.86 KB