| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Swapping columns and rows in table in Excel Sheet
I have a very large table created in an Excel sheet. I need to apply a
statistical formula, requiring that the coulms and rows must be swapped. I know that it can be done easily, but I have forgotten how. Can anyone help? Klavs Dahl Christensen |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Swapping columns and rows in table in Excel Sheet
Have a look at Paste Special / transpose
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Excel Sheet" <Excel wrote in message ... I have a very large table created in an Excel sheet. I need to apply a statistical formula, requiring that the coulms and rows must be swapped. I know that it can be done easily, but I have forgotten how. Can anyone help? Klavs Dahl Christensen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Swapping Rows & Columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping columns?? | Excel Discussion (Misc queries) | |||
| Swapping rows and columns | Excel Worksheet Functions | |||
Linear Mode
