Combine Duplicate Rows in Excel (Mac)

**mike6732** · 11-20-2020, 11:19 AM

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!

**dflak** · 11-25-2020, 09:01 PM

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.

**mike6732** · 11-26-2020, 01:41 PM

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

**dflak** · 11-26-2020, 03:47 PM

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.

**mike6732** · 11-27-2020, 09:44 AM

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!

**dflak** · 11-30-2020, 03:10 PM

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.