Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 23rd 05, 03:04 PM
ROCKWARRIOR
 
Posts: n/a
Default convert columns to rows & rows to columns


Help! I need to change the format of sheet3 of a workbook, making the
rows into columns and the columns into rows. This worksheet has formula
links with the other sheets in that workbook, as well as formula links
in other workbooks. How can this be done and still maintain the
integrity of the information being imported automatically from the
other sheets and workbooks? Can it be done?


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=470216


  #2   Report Post  
Old September 23rd 05, 03:15 PM
swatsp0p
 
Posts: n/a
Default


You can try this:

Insert a blank sheet.

On sheet3, press CTRL+A twice to highlight the entire sheet and press
CTRL+C (to copy the sheet)

go to your new blank sheet and with cell A1 selected, right click and
choose Paste Special... check the Transpose box and click OK

Your sheet should now appear rows to columns and columns to rows.

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=470216

  #3   Report Post  
Old September 23rd 05, 06:31 PM
ROCKWARRIOR
 
Posts: n/a
Default


Bruce, Thanks for the input, but it doesn't quite work. I get a lot
of REF#. Probably because of the links within the original workbook to
sheet1 and sheet2? Is there something I'm missing? Thanks, Kim


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=470216



Reply
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
How to keep rows together when sorting columns? Amit Excel Worksheet Functions 1 March 28th 05 06:01 PM
turn columns into rows chippy Excel Discussion (Misc queries) 1 March 26th 05 08:27 PM
Inverting rows and columns Robkis Excel Discussion (Misc queries) 1 February 25th 05 12:43 AM
repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 03:39 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 03:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017