combine
hi,
i have a sheet in which there are multiple (2 or 3) rows for some values. the only difference between these rows is the values in columns C, D and E. for example cell A1 = "dog". cells C1, D1 and E1 are different for rows 2 and 3. i would like to know how i can combine these rows into one so that we have a concatenation of the rows/columns C, D and E for each entity. thanks in advance, geebee |
combine
Hi Try
="A1"&"c1"&"d1"&"e1" "geebee" wrote: hi, i have a sheet in which there are multiple (2 or 3) rows for some values. the only difference between these rows is the values in columns C, D and E. for example cell A1 = "dog". cells C1, D1 and E1 are different for rows 2 and 3. i would like to know how i can combine these rows into one so that we have a concatenation of the rows/columns C, D and E for each entity. thanks in advance, geebee |
All times are GMT +1. The time now is 10:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com