Have data with multiple records associated to same ID

  • Thread starter Thread starter Dccp_WV
  • Start date Start date
D

Dccp_WV

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
 
How many subsets are you likely to have (maximum)? Are the values DLL,
CND etc in column C, or are they tagged on to the end of the ID in
column B?

Pete
 
One way. Put in c2 and copy down>change to values>delete col B
=IF(LEN(A2)<2,"",RIGHT(B2,3) & " " &RIGHT(B3,3)& " "& RIGHT(B4,3))
 
i would like the list of values CND,DLL to be in column C. And it could be
anywhere from 2 records per ID to 10 records i'm not sure.
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Ashish,

I tried this route and it didn't work. I don't have admin privelages on this
machine so i don't think the add-on installed correctly. I tried the previous
entry and it worked for each individual record but there's no way to do it
for multiple records.

The problem is there isn't a defined number of dup records for each
individual key. One unique key could have as many as ten seperate log types
or as few as one. How do you tell EXCEL to look and match the duplicate keys
and list each unique record attached to it in the format i have specified?
 
I then sorted the entire list by the number of duplicate reocrds and used an
if statement to sort out the duplicates and attached the Concentate fromula
to populate on the cells that met the criteria.

=IF(AND(A3=A2,A4=A3,A5=A4),CONCATENATE(B2&",",B3&",",B4&",",B5),"")
 
Back
Top