Re: [users] Compacting some cells in a different column
My guess is that there is a possibility to write a formula that would be in column D, and maybe also in column E, that would copy and paste the data into columns D and E when there is a name both columns B and C. This would make the copy and paste automatic instead of manually copying and pasting. The formula would say if there was a name in column B and C then copy A and B into D and E. Walter On Tue, Oct 27, 2009 at 2:30 PM, Walter Hildebrandt wrote: > 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 > wrote: > >> Well, the simple answer would probably be to sort columns D and E. >> >> Johnny Rosenberg >> >> >> 2009/10/26 Walter Hildebrandt : >> > 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 >> >> >
Re: [users] Compacting some cells in a different column
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 wrote: > Well, the simple answer would probably be to sort columns D and E. > > Johnny Rosenberg > > > 2009/10/26 Walter Hildebrandt : > > 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 > >
Re: [users] Compacting some cells in a different column
Well, the simple answer would probably be to sort columns D and E. Johnny Rosenberg 2009/10/26 Walter Hildebrandt : > 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
[users] Compacting some cells in a different column
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