Normalize Data for inclusion into Pivot Table

Hello,

So I need to analyze a workbook similar to the one I've provided. Raw tab is basically what the data looks like and Pivot tab is what I need the data to look like to easily manipulate it with a pivot chart.

I can achieve Pivot tab if I spend a lot of time moving data around... but is there an easier way to do this with a formula or macro?

Thanks for the assistance!