| View previous topic :: View next topic |
| Author |
Message |
tetsujin29
Newbie
Joined: 12 Jan 2009
Posts: 3
|
 Posted: Mon Jan 12, 2009 6:59 pm Post subject: how to transpose a column into a row? |
 |
|
Hi, I have a column of text data that I want to transpose on to the first row of another sheet. What is the simplest way to do it in Calc without scripting?
Thanks! |
|
| Back to top |
|
 |
ph1959de
General User
Joined: 16 Aug 2005
Posts: 7
Location: Germany
|
| Posted: Tue Jan 13, 2009 4:02 am Post subject: |
|
|
Please use the help function and search for transpose (that's what I did).
As I do not have the English version of Calc installed here, I'm not completely sure about the correct wording, but basically it is a sequence of Edit/Copy ... Edit/Paste_contents (or is it called Paste_special?). The options menu that comes up on invoking this special paste function offers you a "transpose" switch.
Have fun, Peter |
|
| Back to top |
|
|
tetsujin29
Newbie
Joined: 12 Jan 2009
Posts: 3
|
| Posted: Tue Jan 13, 2009 11:06 am Post subject: |
|
|
| Okay it's working now. THe problem was that if I didn't specify the number of cells in the row upon which the column data was to be pasted, it would result in an overflow error (same data would be pasted over and over to occupy all cells in the row). |
|
| Back to top |
|
|
|
