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

This will do If

First Year start in Column G
Every Year has 7 columns
Between every Year is a blank column

Please Login or Register  to view this content.

Kind regards
Leo

This is perfect. Thank you.

I know this may be a stretch but would it be too much to ask to pseudo-code that script so in case the structure changes, I would be able to recognize which line in the code drives that?