[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Athalon
General User

Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

 Posted: Thu Feb 16, 2006 7:25 am    Post subject: Can this happen I have columns A1:A500, B1:B500, and C1:C500. I need to extract the contents of a few of the rows and put them in 3totally seperate columns, except one right after the other. Lets say I need A:32, B:32, and C:32, A:55,B:55, and C:55, and A:98,B:98, and C:98 extracted to 3 seperate columnsbut in a consecutive row. (This is a much smaller scale than I am working with). I could copy each row and paste one right after the other but with the size of the spreadsheet it would take a long time. Any way to do this? Thanks much.
RickRandom
Super User

Joined: 27 Jan 2006
Posts: 1082
Location: UK

 Posted: Thu Feb 16, 2006 7:30 am    Post subject: I think the method for this will depend on how you have identified which rows you want to extract. Do all the relevant rows have special values in them, or do they have a "Yes" in the adjacent cell, or do you have a list of the specific row numbers, or something else? If you can tell us this, I'm sure there's a way.
Athalon
General User

Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

 Posted: Thu Feb 16, 2006 7:34 am    Post subject: Yes abd No There is no relation between the cells I want to extract, but I did put column D next to columns A,B, and C. If there is a "Yes" in cell in column D, then that is the row I want to extract. To sum, Yes, there is a ryme or reason for which rows I want to extract, but it has nothing to do with themselves, but with whether the cells next to them in column D have a "Yes" in them. Did I explain this correctly? Thanks a bunch.
RickRandom
Super User

Joined: 27 Jan 2006
Posts: 1082
Location: UK

 Posted: Thu Feb 16, 2006 7:46 am    Post subject: Is this the same as in the other post http://www.oooforum.org/forum/viewtopic.phtml?t=31998&sid=532b1bc342cdcc58dc300f8b4e0a3455 or a different but related question?
Athalon
General User

Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA

 Posted: Thu Feb 16, 2006 7:48 am    Post subject: Same One Yes- The same one. I tried to explain it better.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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