View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EllenM EllenM is offline
external usenet poster
 
Posts: 78
Default Normalize/concatenate

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