ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to revert columns to rows (https://www.excelbanter.com/excel-discussion-misc-queries/12129-how-revert-columns-rows.html)

agenda9533

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.





Harald Staff

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.







alMandragor

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.





agenda9533

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.









All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com