Transform data to fix duplicate rows into columns

Hi All,

Thanks for these ideas! However, they seem to only be sorting all data into one row. That's probably my fault for not providing a more robust example.

I've attached some dummy data here. This is a spreadsheet that I need to sort hundreds of rows, giving me usable columns.