LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
PaulFincannon
 
Posts: n/a
Default Converting Rows to Columns?


Hi,

I ran a report which concluded with 1500 lines of data. I would like
to convert each row to a column, which I know how to do using paste
special and transpose. However, is there a way to convert each row so
that it will appear on a different print page without having to
transpose each row individually per page? Thanks in advance!

Puzzled Paul


--
PaulFincannon
------------------------------------------------------------------------
PaulFincannon's Profile: http://www.excelforum.com/member.php...o&userid=19978
View this thread: http://www.excelforum.com/showthread...hreadid=345872

 
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
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
Rows and columns Loi New Users to Excel 0 November 30th 04 07:42 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 11:30 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"