| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to revert columns to rows
example: i need to revert table
A 1 2 3 4 5 6 B C to this format A B C 1 2 3 4 ?????? Thank you. |
|
#2
|
|||
|
|||
|
Copy the cells. Go menu edit paste special and choose "transpose".
HTH. Best wishes Harald "agenda9533" skrev i melding ... example: i need to revert table A 1 2 3 4 5 6 B C to this format A B C 1 2 3 4 ?????? Thank you. |
|
#3
|
|||
|
|||
|
see topic below
"revert table" "agenda9533" wrote: example: i need to revert table A 1 2 3 4 5 6 B C to this format A B C 1 2 3 4 ?????? Thank you. |
|
#4
|
|||
|
|||
|
THANK YOU!!!!!
"Harald Staff" wrote: Copy the cells. Go menu edit paste special and choose "transpose". HTH. Best wishes Harald "agenda9533" skrev i melding ... example: i need to revert table A 1 2 3 4 5 6 B C to this format A B C 1 2 3 4 ?????? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| Rows and columns | New Users to Excel | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Linear Mode
