copy/paste data from nth column into two columns

Hi, please see atatched sample data. I need to convert a tabular table with many more columns than sample document into a table that i can apply pivot table to.

Any loop vba code would be much appreciated.

Hi all, just wondering if I didn't ask my question correctly. I noticed no one has really looked at this question.