| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change ROWS into COLUMNS
Please, HELP!!!
Is there any way in which I can change a huge amount of data that is in row format to columns??????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change ROWS into COLUMNS
If the number of rows is less than the maximum number of columns (256 in
Excel up through 2003; 18,000 and change in Excel 2007) you can copy the data, then do a Paste Special from the Edit menu and choose the Transpose option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "MARY" wrote in message ... Please, HELP!!! Is there any way in which I can change a huge amount of data that is in row format to columns??????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Columns to Rows | Excel Discussion (Misc queries) | |||
| Change the rows to the columns | Excel Discussion (Misc queries) | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| How do you change the rows to columns and columns to rows. | Excel Discussion (Misc queries) | |||
| Can you change rows to columns | Excel Discussion (Misc queries) | |||
Linear Mode
