+ Reply to Thread
Results 1 to 1 of 1

Merging duplicate rows based on comma-delimited cells

  1. #1
    Registered User
    Join Date
    10-10-2019
    Location
    USA
    MS-Off Ver
    Professional Plus 2019 Version 1909
    Posts
    1

    Merging duplicate rows based on comma-delimited cells

    This has also been posted to AND SOLVED Reddit's Excel subreddit. You can find it by searching for "Merging duplicate rows based on comma-delimited cells" on the Excel Subreddit page.

    I would post the link here for reference because that's what the rules state, but I am a new user and currently don't have permissions to provide the link here in my post.

    I want to merge duplicate data that has comma-delimited values in the cells. I know there are ways to merge duplicate rows if the cell contents are Exactly the same, but if the cells contain Comma-delimited values, how could I check if there are duplicates within that? For example: "A,B" in a cell would be considered different from a cell containing "B,A" even though they contain the same values, just in a different order. Is there a macro or formula to get this done for cells that have some similar comma-delimited entries and some different entries? For example:

    In the following table, the 1st column has matching values. Based on the 1st column, I want to merge the values like so:

    From:

    A,B,C,D E
    A,B,F B,E
    1,2 3
    2 3,4
    aaaa,bbb cccc

    Becomes:

    A,B,C,D,F B,E
    1,2 3,4
    aaaa,bbb cccc


    The script/formula would recognize that the 1st and 2nd rows contain duplicates and would merge all of it into 1 cell, despite the fact that the 1st row doesn't have F and the 2nd row doesn't have D. Also notice how the "aaaa,bbb cccc" row hasn't changed because there are no duplicates.
    Last edited by SBMteam; 10-11-2019 at 07:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merging rows based on duplicate values in VBA
    By dkemp354 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2018, 06:16 PM
  2. Replies: 9
    Last Post: 02-04-2016, 08:23 AM
  3. [SOLVED] Multiple cells comma delimited to rows
    By CTRED in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2014, 01:03 PM
  4. [SOLVED] Comma delimited data in multiple cells to rows
    By CTRED in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 03:10 PM
  5. [SOLVED] Merging data vertically in Excel CSV (comma delimited)?
    By SteveJeffs in forum Excel General
    Replies: 4
    Last Post: 05-30-2013, 04:03 AM
  6. Separate comma delimited values to rows
    By grepolis in forum Excel General
    Replies: 3
    Last Post: 01-25-2011, 01:24 PM
  7. Comma Delimited to Rows, Over 255 Records
    By CriticalBill in forum Excel General
    Replies: 1
    Last Post: 01-18-2008, 09:51 PM

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