Help Condensing Data

I am trying to condense data on a spreadsheet. Attached is what I am trying to do. Ultimately I would like to condense the data as shown on the right of the sheet. I am currently doing this manually and it is starting to show how long this would take.

Any help would be appreciated.

Thanks

What determines what goes across?