LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bonnie
 
Posts: n/a
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing problems with columns and rows Ann Shaw Excel Discussion (Misc queries) 0 February 17th 05 05:35 PM
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. JamesR Excel Discussion (Misc queries) 3 January 12th 05 02:18 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
sumif columns and rows Paul Clough Excel Worksheet Functions 2 November 22nd 04 05:01 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"