LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
 
Posts: n/a
Default

hi,
excel will pastespecialtranspose a single column but i am
not aware of an easy way to do a whole table.
you said large table. if you are transposing columns to
rows then you are also tranposing rows to columns and if
you have more that 256 rows to transpose, then you wont be
able to do this because that is all the columns that excel
has.

-----Original Message-----
I have a fairly large table in which I need to switch the

columns to the
rows. Is this possible to do?
.

 
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
Change rows to columns and vise versa Ian Johnson New Users to Excel 2 March 4th 05 02:24 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
In Excel, how do I change the rows into columns? Novice SS User Excel Discussion (Misc queries) 1 February 7th 05 11:13 PM
Newbie questions on spreadsheet WayneC Excel Worksheet Functions 5 December 22nd 04 02:42 AM
Making Rows into Columns Tony Williams Excel Discussion (Misc queries) 1 December 2nd 04 03:47 PM


All times are GMT +1. The time now is 02:50 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"