Ask Your Question

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

asked 2014-02-01 12:18:16 +0200

David gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 06:19:14.214729


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:

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

bolangi gravatar imagebolangi ( 2017-07-04 00:44:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-02-01 12:28:32 +0200

David gravatar image

updated 2014-02-01 12:29:29 +0200

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:
    Paste special
  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.

edit flag offensive delete link more

Question Tools



Asked: 2014-02-01 12:18:16 +0200

Seen: 71,605 times

Last updated: Feb 01 '14