Johnny, you are correct that sorting does "compact" columns D and E. The problem still remains how to get the data out of columns A and B into columns D and E. If it is not possible to get the data out of columns A and B, then it is a help knowing that columns D and E can be "compacted by doing a Sort. (I can manually copy, one row at a time, the rows in column A and B that also have a name in column C, into the same row in column D and E, and at the end Sort to "compact". When a lot of rows are involved it is easier to paste on the same row and at the end doing a Sort. As compared to going up in columns D and E and "compacting" as each row is Pasted.
Walter On Tue, Oct 27, 2009 at 12:16 PM, Johnny Rosenberg <gurus.knu...@gmail.com>wrote: > Well, the simple answer would probably be to sort columns D and E. > > Johnny Rosenberg > > > 2009/10/26 Walter Hildebrandt <wh2...@gmail.com>: > > My question is, how can I do the following? > > > > There are 200 rows involved. The following explains the question. > > > > Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell > A4 > > has 4 > > > > Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has > > name3, cell B4 has name4 > > > > Cell C1 is empty, C2 has hame2 in it, cell C3 is empty, C4 has name4 > > > > The 2 from cell A2 is copied into cell D1 and name2 from cell B2 is > copied > > into > > E1 Also the number 4 in cell A4 is copied into cell D2 and name4 from > cell > > B4 is copied into E2. > > > > In other words when both Columns B and C have the same name in them then > > columns A and B are copied to columns D and E and everything that is > copied > > is "compacted" so there are on empty rows between what is copied into > > columns D and E > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >