Switch Rows and Columns

B

Bonnie

Hi there. Using E02 on XP. Have a spreadsheet set up like:

Pimco USBNA OMNI Bond
1yr 3.55% 2.94% 1.92% 5.14%
2yr 2.85% 1.43% 5.44% 6.43%
3yr 5.34% 2.94% 5.44% 3.65%

Need to 'flip' it to:

1yr 2yr 3yr
Pimco 3.55% 2.85% 5.34%
USBNA 2.94% 1.43% 5.44%
OMNI etc.
Bond

Saw it a few weeks ago and didn't make a note, now I need
to do it. Can't remember the terminology. Thanks in
advance for any help or advice!
 
J

JulieD

Hi Bonnie

you can copy your data and then use
edit / paste special / transpose to "flip" it

Cheers
JulieD
 
B

Bonnie

Hey Julie,

Thanks for the info - transpose - couldn't remember it.
Thanks bunches!

B
 
Top