Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a block of data, e.g. 30 rows and 20 columns. How do I switch them,
i.e. put the data A1-T1 to A1-A20, A2-T2 to B1-B20, A3-T3 to C1-C20 and so on? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
switch rows and columns | New Users to Excel | |||
Switch Rows and Columns | Excel Discussion (Misc queries) |