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

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
>