+ Reply to Thread
Results 1 to 6 of 6

Combine Duplicate Rows in Excel (Mac)

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    London, UK
    MS-Off Ver
    Office 2019 (Mac)
    Posts
    12

    Combine Duplicate Rows in Excel (Mac)

    Hi all,

    Apologies if this has been covered before. I've found a few solutions to this problem, but all relate to Windows versions of Excel.

    Basically I'm looking for help coming up with a VGA script that will merge order lines based on duplicate values in one column. So Rows 1-10 in the attachment would be output as Rows 12-17.

    Any pointers here would be massively appreciated! Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,093

    Re: Combine Duplicate Rows in Excel (Mac)

    Would a pivot table work for you? I created on and then used the design ribbon to display the table in tabular format, turn off row and column totals and finally turn off subtotals. That's the quick and dirty way of doing it.

    The second file shows how it is done in VBA - I still use pivot tables.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    04-08-2020
    Location
    London, UK
    MS-Off Ver
    Office 2019 (Mac)
    Posts
    12

    Re: Combine Duplicate Rows in Excel (Mac)

    Thank you so much for getting back to me on this! I'm unfamiliar with pivot tables, but I think this might actually work nicely.

    Can I just ask how you run the macro? I'm looking at the Raw Data tab in Template2, but when I try to run the macro Excel doesn't appear to do anything to it..?

    Thanks again!

    Mike

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,093

    Re: Combine Duplicate Rows in Excel (Mac)

    You need to do two things: 1. Make sure you enable the contents and 2. Go to View -> Macros than open the Macros and run it.

  5. #5
    Registered User
    Join Date
    04-08-2020
    Location
    London, UK
    MS-Off Ver
    Office 2019 (Mac)
    Posts
    12

    Re: Combine Duplicate Rows in Excel (Mac)

    Thanks! I have the macro running, but I'm unclear what it's actually doing. For instance, if I delete all data in the "Report" sheet and run the macro, the data will be repopulated on that sheet. If I delete all data in the "Report" and "WPT" sheets and run the macro, nothing happens. And if I change the data in the "Raw Data" sheet, these changes are not reflected on either of the other sheets after running the macro.

    Apologies if I'm missing something obvious here!

    Thanks in advance!

  6. #6
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,093

    Re: Combine Duplicate Rows in Excel (Mac)

    Attached is a "quick and dirty" explanation of what I did. I strongly recommend you take to heart the mini-tutorial on Excel Tables. I use them almost all the time now. The sooner you learn them, the sooner you'll wonder how you ever got along without them.
    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. [SOLVED] Trying to combine duplicate rows into one records
    By vlo2020 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-28-2020, 06:07 PM
  2. [SOLVED] Combine Duplicate Rows and Sum the Values
    By Neuk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2018, 09:17 AM
  3. combine duplicate rows
    By asmi in forum Excel General
    Replies: 6
    Last Post: 02-25-2015, 03:15 PM
  4. Combine duplicate rows with conditions
    By jamesforpm in forum Excel General
    Replies: 11
    Last Post: 07-25-2014, 03:55 AM
  5. Combine Duplicate Rows and Combine Data in Rows
    By cherylmcgk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 12:04 PM
  6. [SOLVED] Combine duplicate rows into a single row in Excel
    By jkshaver in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2012, 10:49 PM
  7. Find and combine duplicate rows
    By treva26 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2007, 09:14 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