This video shows how you can merge and consolidate rows with duplicate data using the Combine Duplicate Rows add-on. Three simple yet advantageous steps will let you select data and pick columns to merge or concatenate.
Combine Duplicate Rows is a simple three-step tool, yet it’s a lot more useful than it may seem at first.
There are three major things this add-on will do for you:
Let’s look at three simple steps that let you do the same in your table.
As an example, I have a table with orders some of which should go to the same customers. So I’ll find Power Tools, open the Merge and Combine group, and click Combine duplicate rows:
I can also manage case differences and blanks using these checkboxes at the top.
Now, let’s go to the most interesting step.
So I can choose to merge the values that I want to keep, like product names, and pick or enter a delimiter between them. Or I can calculate numbers, for example, sum them.
One very convenient option here is deleting duplicate values in the columns you’re merging, so it will keep just the uniques.
Now I have all orders perfectly merged by customer and address, with a list of products, and the totals neatly calculated.
Combine Duplicate Rows is a part of Power Tools add-on that boasts a great collection of similar time-savers. You can find it in the add-ons store, and if you have any questions, you can always contact us for assistance.