From: minyeh on
On Mar 10, 4:09 am, EllenM <Ell...(a)discussions.microsoft.com> 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.105<br
> />175.300<br />175.380<br />175.390<br />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)