How do I convert rows into columns (or vice versa) in Calc? [closed]
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?
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'