+ Reply to Thread
Results 1 to 4 of 4

Macro to concatenate cells adjacent to duplicates

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro to concatenate cells adjacent to duplicates

    Hi,

    I have a excel 2010 sheet with approx 32,000 rows of customer addresses and job ID numbers. I want to delete duplicate addresses but concatenate job ID numbers. I need to find the duplicates, concatenate the adjacent cells and then remove duplicates.

    Example:

    Column A | Column B
    45 Park Avenue| 99675
    45 Park Avenue| 99870
    91 Bay Street | 54678
    74 Main Street | 65478
    74 Main Street | 67456

    Result:

    Column A | Column B
    45 Park Avenue| 99675, 99870
    91 Bay Street | 54678
    74 Main Street | 65478, 67456

    I have searched a lot of threads, nothing so far fits exactly what I am trying to do, I am a fairly novice user

    Is this possible? THANKS!
    Last edited by 084851; 02-27-2013 at 10:23 PM.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Macro to concatenate cells adjacent to duplicates

    Give this a try, assumes your data starts in row 2

    Edit Change Set ws = Worksheets("sheet2") to the name of your sheet
    Please Login or Register  to view this content.
    Last edited by mike7952; 02-27-2013 at 10:51 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Macro to concatenate cells adjacent to duplicates

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Macro to concatenate cells adjacent to duplicates

    AWESOME! thank you. you saved me hours and hours! Worked great

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1