+ Reply to Thread
Results 1 to 5 of 5

Help merging duplicate entries with unique information

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help merging duplicate entries with unique information

    Hi,

    I am trying to combine duplicates entries in one column, while preserving the unique information in each row from the duplicate.

    A1; B1; C1
    A2; B2; C2
    A3; B3; C3

    into this:

    A1; B1; C1; B2; C2; B3; C3

    So that if A1=A2=A3 and they are therefore duplicates, it will combine the information in each row by adding a new column.

    I actually have a larger data set (i'm talking hundreds of thousands of entries) that I need to do this with.

    I attached a snippet of it. I am trying to merge any duplicates from the first column (Desy_Sort_key) so that there are only unique numbers there, but without losing information from the other columns.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help merging duplicate entries with unique information

    Let me understand, if a duplicate is found then if the clm_... is not listed add a new column in the row of the first one. dont delete the duplicate, right?

  3. #3
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Help merging duplicate entries with unique information

    This sounds exactly like this thread.
    多么想要告诉你 我好喜欢你

  4. #4
    Registered User
    Join Date
    02-11-2014
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help merging duplicate entries with unique information

    RCM.

    Yes, basically. I want to delete the duplicates eventually so that all the data from the duplicates is consolidated into 1 row. It needs to be separate columns for each piece of data because I need to then code them as 0s and 1s so I can analyze it.

    Hope that helped clarify.

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help merging duplicate entries with unique information

    i got the first part working
    Attached Files Attached Files

+ 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 Duplicate Entries
    By Alex_Avilla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2013, 04:19 AM
  2. Remove duplicate entries when merging 2 worksheets based on certain criterias
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 06:07 AM
  3. Replies: 0
    Last Post: 09-18-2011, 06:48 PM
  4. Duplicate Entries into List of Unique Entries
    By MjRmatt in forum Excel General
    Replies: 1
    Last Post: 08-18-2010, 11:53 AM
  5. merging information from partial duplicate rows
    By Todd in forum Excel General
    Replies: 2
    Last Post: 08-17-2006, 04:50 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