Would pivot tables work with this

I'm currently trying to build a template form to ease my work load; however I'm running into a bit of a snag. I know pivot tables can do quite a bit; however I can't seem to wrap my head around this.

I've attached an Excel file with two tabs. One contains a sample "Raw Data" dump, whereas the other tab ("Result") is what I want it to look like when I'm done with it. The items in "red" are the titles for the data.

I guess my question would be: Is pivot tables the right way of doing this, or should I do it a different way? In some cases when I receive a dump of the data, its quite large in size; therefore to go through it all to clean it up is quite time consuming. If this isn't the best way of doing this, then would it be better to do some VBA instead?

Thanks,
-Brando-