+ Reply to Thread
Results 1 to 11 of 11

Combining Duplicate Rows and Seperating Data with Commas

  1. #1
    Registered User
    Join Date
    11-01-2013
    Location
    Savage, MD
    MS-Off Ver
    Excel 2013
    Posts
    6

    Question Combining Duplicate Rows and Seperating Data with Commas

    I have a list of 7000+ rows, and columns A through H. Column A contains full names and B : H has other unique information, sometimes blanks. Usually where there are 2 duplicate names, for example A2 and A3, A2 has data in columns B - E and then A3 has data in F - H. But where they both have different data, I want it put together and separated by a comma.

    EX:
    A B C
    2 Z Y
    2 L
    2 A
    3 D K
    4 Y Y
    4 M

    Would become:
    A --- B ---- C
    2 --- Z, A - Y, L
    3 --- D ---- K
    4 --- Y ---- Y, M

    I attached a sample sheet of data.
    Thank you in advance!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combining Duplicate Rows and Seperating Data with Commas

    Duplicate post

    http://www.excelforum.com/excel-prog...th-commas.html

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Combining Duplicate Rows and Seperating Data with Commas

    Hi and welcome to the forum

    This is a duplicate thread, but the data is better presented here than on the other thread, so I will close the other 1, you can continue on this 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    11-01-2013
    Location
    Savage, MD
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Combining Duplicate Rows and Seperating Data with Commas

    Yeah, thanks guys...

    Unfortunately your post does not comply with Rule 489 Subsection F.110 of our Forum Rules. If you aren't part of the solution, you are part of the problem.

    So back to the actual issue at hand..

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combining Duplicate Rows and Seperating Data with Commas

    You are more likely to get a reply if you attach your desired result. There are too many unknowns.
    The fact that you have over50 views indicate that no-one has read your mind yet.

  6. #6
    Registered User
    Join Date
    11-01-2013
    Location
    Savage, MD
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Combining Duplicate Rows and Seperating Data with Commas

    Touche.
    Please assist me in transforming Sample Set Sheet 1 into Sample Set Sheet 2.

    Unfortunately you have violated Rule 1595 Subsection P Paragraph 11 that states I sense a little sarcasm. That's not allowed.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-01-2013
    Location
    Savage, MD
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Combining Duplicate Rows and Seperating Data with Commas

    Just stumbled upon an add-in called Combine Rows by Ablebits... I NO LONGER NEED ANY OF YOU. THANKS.

    Unfortunately I probably just violated some rule that probably says no caps lock, because YELLING ISN'T ALLOWED.

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combining Duplicate Rows and Seperating Data with Commas

    The output is on sheet3.
    Attached Files Attached Files

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Combining Duplicate Rows and Seperating Data with Commas

    aly, if you cannot show some respect to members here, you will be removed!

  10. #10
    Registered User
    Join Date
    11-15-2013
    Location
    Cleveland, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Combining Duplicate Rows and Seperating Data with Commas

    I am trying to solve the same issue as the original poster, so I looked at your solution; however
    the output on sheet 3 doesn't match the desired outcome on sheet 2 (blank cells and filled cells seem to be combined as desired, but cases in which both cells from "matched" rows have different values don't seem to have been combined into comma-delimited lists as desired).

  11. #11
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combining Duplicate Rows and Seperating Data with Commas

    jeffocasm,
    Welcome to the forum!
    Please read forum's rule.
    You need to start your own thread.

+ 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. Combining Duplicate Rows and Seperating Data with Commas
    By aly0627 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:44 PM
  2. Combining data in duplicate rows, Excel 2007
    By tsdet08 in forum Excel General
    Replies: 8
    Last Post: 07-25-2013, 11:19 AM
  3. Combining Duplicate Columns with the different data in their rows
    By cleefred in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-21-2013, 10:42 AM
  4. [SOLVED] Combining rows with both unique and duplicate data
    By CNFlora in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2013, 05:09 PM
  5. Combining Rows With Duplicate Data
    By Jaricketts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2010, 01:21 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