View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dccp_WV Dccp_WV is offline
external usenet poster
 
Posts: 1
Default Have data with multiple records associated to same ID

My Data Situation:

A B
33007014220000 33007014220000 DLL
33007014220000 CND
33007014220000 CBL

Need to get it like this:
A B
33007014220000 CBL,CND,DLL


Is there a way to do this via formulas or code? I am doing it by hand and
will take days to go through 1683 Unique records.

Thanks for your help!
Dan