I have some data spread out in rows. Now I've entered it, I really would prefer to see it in columns. Is there a way to do this automatically in Calc (i.e., change a row presentation into columns)?
And if I can do it as columns --> rows, I expect it will also work for the opposite switch, rows --> columns. Correct?
As it happens, this is quite easily done:
click top-left cell, then shift-click bottom right cell. You should how have copied all the rows of data that you want to convert into columns of data.CTRL-C to copy.click the cell where you want to paste your new columns.Shift-CTRL-V, or use Edit > Paste Special... from the toolbar to bring up this dialog: 
Transpose option is selected, then click OK. Done!The same process works in either direction (cols-to-rows, rows-to-cols).
Credit: I couldn't find this on AskLibo, and have followed these Excel instructions.
Asked: 2014-02-01 12:18:16 +0100
Seen: 70,453 times
Last updated: Feb 01 '14
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
I would like to accomplish something similar, however preserving formulas. It seems as if it may be possible with macros by (1) specifying a range, (2) iterating over it (3) calculating the transposed coordinates for the current cell, and (4) copying the current cell contents to the transposed location. I would appreciate any hints or pointers to sample code.
My attempt using perl is here: http://paste.debian.net/974649/
Running this code got many errors: 'Element is already part of tree'