Transpose Column to Row

[Closed]
Report
Posts
1
Registration date
Thursday December 4, 2014
Status
Member
Last seen
December 5, 2014
-
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