Normalize/concatenate

On Mar 10, 4:09*am, EllenM wrote:
Hello,
I have a data set that looks like this:
Sortterm * * * *Doc # * Main Term * * * * * * * * * * * * * * * * * * * CAS # * CFR REG #
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE *000117817 * 175.105
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE *000117817 * 175.300
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE *000117817 * 175.380
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE *000117817 * 175.390
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE *000117817 * 176.170

I'd like to concatentate the last column with the unique values to look like
this:
Sorterm * * *DocNum *Mainterm * * * * * * * * *CAS * * *Regnum
DIPHTHALATE *7065 * * * DI(2-ETHYLHEXYL) PHTHALATE * * *000117817 * * * 175.105br
/175.300br /175.380br /175.390br /176.170
Thanks in advance,
Ellen

why don't u just use a pivot table? it would be easier and it hide
duplicate value.
another way would be to show all the value and hide the duplicates
using a formula like
AA2=IF(A2=A1,"",A2) for all the columns u want to hide duplicate value
(input in A2:E100, output in AA2:AE100)