Changing structure of data

Hi All,

I am trying to change the structure of some information. I basically have 2 fields 'Questions' (Vertical axis) and 'Structures' (Horizontal axis). There are 4 questions (A-D) , and there are 4 structures (1-4).

On sheet 1 there is a table that has each question once (Vertical axis) and each structure once (Horizontal axis). But what I want to do is change the structure so each question is reported vertically and repeated by the number of structures i.e. question A, 4 times (vertically) with the structure reported in the next column (vertically) on sheet 2.

I have tried various things by using loops, offset and count to get this to work but I am new to VBA and still no luck. Please find an example attached.

Any help would be greatly appreciated.


Regards,

Forrestgump