How do I convert rows into columns (or vice versa) in Calc?

[dajare]

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?

[bolangi]

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: Debian paste error

Running this code got many errors: ‘Element is already part of tree’

[dajare]

As it happens, this is quite easily done:

1. Select the area of data you want to “convert”, e.g., 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.
2. Hit CTRL-C to copy.
3. Go to a new worksheet, click the cell where you want to paste your new columns.
4. Either hit Shift-CTRL-V, or use Edit > Paste Special... from the toolbar to bring up this dialog:
   
5. Ensure that the 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.}