flip data (columns into rows)

[Todd]

I have a data sheet with the data

Jan 1 2 3
Feb 2 3 1
March 3 1 2

and I want to set it up like

Jan Feb March
1 2 3
2 3 1
3 1 2

I read how to do this without remaking the sheet once.
Now I can't remember what I am supposed to do. Or where I
read it at.

Can someone help me?


TIA

Todd

 

[Frank Kabel]

Hi Todd
- copy this range
- goto 'Edit - Paste Special' and choose 'transpose'