OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

how to transpose a column into a row?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
tetsujin29
Newbie
Newbie


Joined: 12 Jan 2009
Posts: 3

PostPosted: Mon Jan 12, 2009 6:59 pm    Post subject: how to transpose a column into a row? Reply with quote

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
View user's profile Send private message
ph1959de
General User
General User


Joined: 16 Aug 2005
Posts: 7
Location: Germany

PostPosted: Tue Jan 13, 2009 4:02 am    Post subject: Reply with quote

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
View user's profile Send private message
tetsujin29
Newbie
Newbie


Joined: 12 Jan 2009
Posts: 3

PostPosted: Tue Jan 13, 2009 11:06 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group