hi all,
its maybe a stupid question but i wonder if it is possible to
swap the rows with the columns
so to say turn the table around 90 degrees?
thx for answers
[Solved] Column row swap (transpose)
-
- Posts: 2
- Joined: Wed Apr 08, 2009 12:29 am
[Solved] Column row swap (transpose)
Last edited by Hagar Delest on Wed Apr 08, 2009 8:21 am, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OOo 2.3.X on MS Windows Vista
Re: column row swap
Yes, you can do this with Paste Special Transpose. The procedure is:
1.Select the cell range that you want to transpose.
2.Choose Edit - Cut.
3.Click the cell that is to be the top left cell in the result.
4.Choose Edit - Paste Special.
5.In the dialog, mark Paste all and Transpose.
If you now click OK the columns and rows are transposed.
1.Select the cell range that you want to transpose.
2.Choose Edit - Cut.
3.Click the cell that is to be the top left cell in the result.
4.Choose Edit - Paste Special.
5.In the dialog, mark Paste all and Transpose.
If you now click OK the columns and rows are transposed.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 2
- Joined: Wed Apr 08, 2009 12:29 am