Switch Rows and Columns
 

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!

Hi Bonnie

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

Cheers
JulieD

"Bonnie" wrote in message
...
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!

Hey Julie,

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

B

-----Original Message-----
Hi Bonnie

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

Cheers
JulieD

"Bonnie" wrote in
message
...
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!


.

you're welcome :)

"Bonnie" wrote in message
...
Hey Julie,

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

B

-----Original Message-----
Hi Bonnie

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

Cheers
JulieD

"Bonnie" wrote in
message
...
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!


.