| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interchange Columns and Rows in a Table
Is it possible to interchange the columns and the rows in a tables together
with the data. Ex. if the rows represent the months and the columns represent the customers and the data represents the sales for each month. how can I change the customers in to rows and the months in to columns. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interchange Columns and Rows in a Table
Use pastespecial. You have to paste the data in a new area on your worksheet
and then copy back to the original area after you finish. 1) Highlight the area you want transpose and copy. 2) Select the first cell where you want the tranposed data. Then right Click and select PasteSpecial. Select transpose and press OK. "Lawrence" wrote: Is it possible to interchange the columns and the rows in a tables together with the data. Ex. if the rows represent the months and the columns represent the customers and the data represents the sales for each month. how can I change the customers in to rows and the months in to columns. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interchange Columns and Rows in a Table
great help, thanks
"Joel" wrote: Use pastespecial. You have to paste the data in a new area on your worksheet and then copy back to the original area after you finish. 1) Highlight the area you want transpose and copy. 2) Select the first cell where you want the tranposed data. Then right Click and select PasteSpecial. Select transpose and press OK. "Lawrence" wrote: Is it possible to interchange the columns and the rows in a tables together with the data. Ex. if the rows represent the months and the columns represent the customers and the data represents the sales for each month. how can I change the customers in to rows and the months in to columns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table rows & columns query | Excel Discussion (Misc queries) | |||
| Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
| interchange rows and columns | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
