Results 1 to 11 of 11

Combining Duplicate Rows and Seperating Data with Commas

Threaded View

  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

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