Transpose Column to Row

Closed
allykoh Posts 1 Registration date Thursday December 4, 2014 Status Member Last seen December 5, 2014 - Dec 5, 2014 at 12:01 AM
Hi All,
I have list of data need to transpose as below. Anyone can help with the macro?
Thank you.

From

Material Des ww1 ww2
A Q 1 4
B E 2 5
C R 3 6

TO

Material Des date Figure
A Q ww1 1
A Q ww2 4
B E ww1 2
B E ww2 5
C R ww1 3
C R ww2 6