Combine duplicate rows in Google Sheets

The add-on is designed to merge data from duplicate rows in Google Sheets based on unique column. For example, it can calculate the total money spent by each loyal customer even if the customer's name appears more than once in your table.

It does equip you with a couple of functions like UNIQUE, FIND, and QUERY. But if they are not familiar to you, you'll have to spend time over the tutorials to build working functions for your tables.

Our add-on is simple and intuitive and lets you solve the task in a matter of seconds.

Run Combine rows from the Merge & Combine group in Power Tools and follow these steps:

1. Select the necessary data range.
2. Identify columns with duplicate records.
3. Choose the columns to combine and either:
   • Merge values using delimiters.
   • Or calculate numbers with the help of some functions.
4. Click Finish.

See a more detailed description here.

Your table may contain multiple columns with duplicate records, i.e. authors' first and last names. The add-on scans these for repeated values and collects the data from the same rows but from other columns, i.e. book titles.

You can pick from 4 built-in delimiters: comma, semicolon, space, line break.

But you are free to enter any other delimiter you'd like to see.

The add-on offers 14 functions to process your data: SUM, COUNT, COUNTA, AVERAGE, AVERAGEA, MIN, MAX, PRODUCT, MODE, STDEV, STDEVP, VAR, VARP, MEDIAN.

Yes, but COUNTA only. It can count the number of occurred records, i.e. ordered products, instead of listing their names.

Not at all. If you know you'd like to merge them in the same way, you can synchronize the action for all columns with a corresponding option.

It's entirely up to you. We've prepared the options to ignore empty cells in both key and additional columns.