+ Reply to Thread
Results 1 to 8 of 8

Unify/merge/mix rows based on duplicate cells

  1. #1
    Registered User
    Join Date
    07-30-2015
    Location
    944
    MS-Off Ver
    MAC 2011
    Posts
    4

    Talking Unify/merge/mix rows based on duplicate cells

    Hello everybody, I'm Alejandro from Argentina. I'll do my best to explain myself in English, please try to understand me.

    Im working with a database where I have columns with some information, and columns with some other information. I need to mix those columns, based on one particular duplicate cell, which is the cell that identifies that they can be mixed.

    Its easier to understand it looking at the file attached...

    THANKS!Captura de pantalla 2015-07-30 a las 11.59.40.png

  2. #2
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Unify/merge/mix rows based on duplicate cells

    Please post an example file. How do you want to deal with contradictory fields? Your example shows only cases where one record has a value and the other is blank. What happens when both have values, but they are not the same?

  3. #3
    Registered User
    Join Date
    07-30-2015
    Location
    944
    MS-Off Ver
    MAC 2011
    Posts
    4

    Re: Unify/merge/mix rows based on duplicate cells

    There won't be a case in which one has a value and the other is not the same. It will always be like this, one will have a value and the other will be blank. How do I attach a file now?

  4. #4
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Unify/merge/mix rows based on duplicate cells

    See "How do I attach a file to a post?" on the page below:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  5. #5
    Registered User
    Join Date
    07-30-2015
    Location
    944
    MS-Off Ver
    MAC 2011
    Posts
    4

    Re: Unify/merge/mix rows based on duplicate cells

    There it goes
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Unify/merge/mix rows based on duplicate cells

    Try this (using my 'Excel Data Engine')

    PARA_FORO_cy.xlsm

  7. #7
    Registered User
    Join Date
    07-30-2015
    Location
    944
    MS-Off Ver
    MAC 2011
    Posts
    4

    Re: Unify/merge/mix rows based on duplicate cells

    Sorry and thank you so mucha, but, I just don't know what to do with that!

  8. #8
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Unify/merge/mix rows based on duplicate cells

    1. Drop your 7000 records in at Input!A4
    2. Change duplicate heading 'AŅO' in D4 to 'AŅO2'
    3. Click the Execute button
    4. Collect your merged results in sheet Output

+ 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. Delete duplicate rows based on values of cells
    By phixate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2014, 04:49 PM
  2. Replies: 2
    Last Post: 04-08-2014, 04:44 AM
  3. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  4. Help Concatinating cells from a column based on duplicate rows
    By Rabid Squirrel in forum Excel General
    Replies: 9
    Last Post: 11-02-2011, 04:42 PM
  5. duplicate rows...merge cells
    By matinha052 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-20-2010, 07:40 AM
  6. Merge rows based on duplicate cell
    By skacutter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2010, 09:47 AM
  7. Merge cells and remove duplicate rows
    By mbgritten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2009, 10:55 AM

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