+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Concatenating Names based on adjacent duplicate values

  1. 01-19-2012, 03:32 PM #1
    esphero
    esphero is offline
    Registered User
    Join Date
    01-19-2012
    Location
    Pensacola, FL
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    8

    Concatenating Names based on adjacent duplicate values

    This is a small example of the project I'm slamming my head into:


    99988 John
    99989 John
    99990 John
    99991 Chad
    99991 Alice
    99992 Chad
    99993 Chad
    99994 Chad
    99995 Chad
    99996 Chad
    99997 Chad
    99998 Chad
    99998 Alice
    99999 Chad

    What I'm trying to do is concatenate the names by number, either removing duplicates in the process, or populating an already existing list that doesn't have duplicates. So, ideally the end result would look like this:

    99988 John 99988 John
    99989 John 99989 John
    99990 John 99990 John
    99991 Chad 99991 Chad, Alice
    99991 Alice 99992 Chad
    99992 Chad 99993 Chad
    99993 Chad 99994 Chad
    99994 Chad 99995 Chad
    99995 Chad 99996 Chad
    99996 Chad 99997 Chad
    99997 Chad 99998 Chad, Alice
    99998 Chad 99999 Chad
    99998 Alice
    99999 Chad

    Any help at all would be appreciated in helping figure this out. I've quite honestly run out of ideas.

    Thank you very much!
    Reply With QuoteRegister To Reply
  2. 01-20-2012, 03:16 PM #2
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Concatenating Names based on adjacent duplicate values

    Try this...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-24-2012, 02:01 PM #3
    esphero
    esphero is offline
    Registered User
    Join Date
    01-19-2012
    Location
    Pensacola, FL
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    8

    Re: Concatenating Names based on adjacent duplicate values

    (See Next Reply, this one was in error and I cannot delete)
    Last edited by esphero; 01-24-2012 at 02:09 PM.
    Reply With QuoteRegister To Reply
  4. 01-24-2012, 02:07 PM #4
    esphero
    esphero is offline
    Registered User
    Join Date
    01-19-2012
    Location
    Pensacola, FL
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    8

    Re: Concatenating Names based on adjacent duplicate values

    ZipName_Concatenate.xlsx

    So I tried this but it seems to be taking quite a long time, not only that it gave me an error. I also realize in my original post that I typically have about 40k + rows of zip codes with a name attached to the zip. I changed the "Num_List" to "A1:A40547" and run the macro on A2 since my list has headers.

    I have attached a copy of the sheet we need it to work on, but no macro within the sheet

    Dangelor, I appreciate your help so far!
    Last edited by esphero; 01-24-2012 at 02:08 PM. Reason: Did not put corrected message
    Reply With QuoteRegister To Reply
  5. 01-24-2012, 03:20 PM #5
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Concatenating Names based on adjacent duplicate values

    This should be faster...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1