Converting like data in rows to column

[April.Ryniewicz]

I am not a macro expert and I've spent a better part of a day trying to find this online but can't seem to find anything that is as complex as I required. Basically this is what I need:

I have a spreadsheet that is a data dump from a system, the data comes out in separate rows for a single "fee type", I'm looking for a systematic (macro) way to convert the multiple rows into a single row and insert the 'differentiating' data into a column. Attached is an example of the data dump from the system and theoretically what I'd like the data to be converted to make it easier to query.