| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing rows insted of columns
Hello
I have an excel sheet with some information on it which has 3 column but lots of rows. I prefer to change order (reversing the information on column and rows). Is it possible? Thanks BHR |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing rows insted of columns
Look at TRANSPOSE function.
It is possible but remember you only have 256 columns so if your number of rows is greater than this, a simple transposition will not work. Can you let us know the exact range of data and how you want them transposed. "Bahareh" wrote: Hello I have an excel sheet with some information on it which has 3 column but lots of rows. I prefer to change order (reversing the information on column and rows). Is it possible? Thanks BHR |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing rows insted of columns
Hi
Select your range, and copy it. Select a cell as leftmost upper corner of new datarange (NB! old and new datarange must NOT intersect), and then PasteSpecial with Transpose checked. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Bahareh" wrote in message ... Hello I have an excel sheet with some information on it which has 3 column but lots of rows. I prefer to change order (reversing the information on column and rows). Is it possible? Thanks BHR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
| Changing Columns to Rows Question | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
