Reshape data and unpivot

Hello all,

I am new to macros and beginning to gain an understanding...not quite at the point where I can write my own yet.

I am looking to take a worksheet and unpivot the data and delete a few columns in the process. I have attached a workbook as an example. The tab "original" has the data in it's current form. The tab "unpivoted" has the columns I want and in the format i am trying to put them in.

Thank you for your help in advance!

-HP