[Solved] Column row swap (transpose)

Discuss the spreadsheet application
Post Reply
florian_wg
Posts: 2
Joined: Wed Apr 08, 2009 12:29 am

[Solved] Column row swap (transpose)

Post by florian_wg »

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
Last edited by Hagar Delest on Wed Apr 08, 2009 8:21 am, edited 1 time in total.
Reason: tagged [Solved].
OOo 2.3.X on MS Windows Vista
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: column row swap

Post by FJCC »

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.
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.
florian_wg
Posts: 2
Joined: Wed Apr 08, 2009 12:29 am

Re: column row swap

Post by florian_wg »

thx alot, that really helps me out

cheers
OOo 2.3.X on MS Windows Vista
Post Reply