macro for pivoting

[mojaman]

i have a data like this for forecast for different items

item Q1 Q2 Q3 Q4
---- -- -- -- --

X1 1000 0 0 5000
X2 500 400 300 100
X3 20 1000 100 90

now i want to know about a macro that can transform the data to this

item-> X1 X2 X3
------ --- --- ---
Q1

Q2

Q3

Q4

thank you for your help.

sanjay.

 

[straus]

copy the data, go to another cell, go to paste special and check transpose and click ok

 

[mojaman]

straus
thank you.
sanjay.