Can this happen

Athalon · 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

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 · 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

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 · Posted: Thu Feb 16, 2006 7:48 am Post subject: Same One

Yes- The same one. I tried to explain it better.