Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Yasser
 
Posts: n/a
Default How can i convert the rows into columns and columns into rows?

Hi,
I have a table consists of columns and rows,just i want to convert every
column to be a row and every row to be column .
Thanks in advance.
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

edit-copy-edit- pastespecial- transpose


Yasser wrote in message
...
Hi,
I have a table consists of columns and rows,just i want to convert every
column to be a row and every row to be column .
Thanks in advance.



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
Data in table, may need to convert to columns with OFFSET? Ron H Excel Discussion (Misc queries) 5 July 31st 05 06:44 PM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
How to convert columns of data to one column of text devlkat Excel Worksheet Functions 3 April 6th 05 04:08 PM
How to keep rows together when sorting columns? Amit Excel Worksheet Functions 1 March 28th 05 06:01 PM
every nth cell by columns not rows.... Sampson Excel Worksheet Functions 1 February 24th 05 06:03 AM


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