| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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! . |
|
#4
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Linear Mode
