Transposing from multiple lines to single line with multiple related columns

I am not quite sure how to transpose multiple values in a massive spreadsheet. The output is vertical in a table format with unique products per line mapped to an ID. I need to achieve unique products each in their own column per ID. Please see attachment.

Thanks in advance for your help.