+ Reply to Thread
Results 1 to 5 of 5

Move data on duplicate rows (different columns) to one row and delete extra rows?

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Suomi
    MS-Off Ver
    Excel 2010
    Posts
    7

    Move data on duplicate rows (different columns) to one row and delete extra rows?

    Hi,

    I've got 3000+ rows of data, in which duplicate (and triplicate, quadruplicate... etc) rows (@ column A) are present. I want to get rid of those extra rows and the data on them moved to a single row.
    The values in duplicate rows are never on the same column.
    Here's sample data on one sheet. The upper table shows an example of "before" and the lower one is an example of "after".

    Sample_data_vba.xlsx

    Regards,
    Sagwa
    Last edited by Sagwa; 03-01-2014 at 08:35 AM.

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

    Re: Move data on duplicate rows (different columns) to one row and delete extra rows?

    Sagwa ,
    There is a button on sheet 1 column Q. Just press it.
    Attached Files Attached Files

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Move data on duplicate rows (different columns) to one row and delete extra rows?

    Hi,

    See attached sheet2.
    First list the unique column A values on sheet 2. Use Copy and remove duplicates.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    02-28-2014
    Location
    Suomi
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Move data on duplicate rows (different columns) to one row and delete extra rows?

    THANK YOU AB33!

    Unbelievable. I'm speechless.
    I don't think you can imagine how much this helps. Seriously!

    Thank you. Hugs, kisses, everything!

    ~Sagwa

  5. #5
    Registered User
    Join Date
    02-28-2014
    Location
    Suomi
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Move data on duplicate rows (different columns) to one row and delete extra rows?

    Richard,

    I didn't quite get the idea, maybe because of the excitement AB33's code caused .

    Thank you anyway for your help.

    ~Sagwa

+ 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. [SOLVED] Delete rows that have duplicate data in certain columns
    By aarodn in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-23-2013, 07:48 PM
  2. Replies: 6
    Last Post: 03-04-2013, 12:03 AM
  3. Delete duplicate rows with same data in certain columns for million rows
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-08-2012, 12:53 AM
  4. take extra columns of rows and move to new line
    By rampart551 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2011, 10:01 PM
  5. delete extra columns and rows
    By matt charlton in forum Excel General
    Replies: 1
    Last Post: 06-08-2005, 11:05 AM

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