Combine duplicate rows in Google Sheets
Merge and consolidate rows with duplicate data
This smart utility combines multiple rows into one based on duplicates in 3 steps. Just pick all columns with repeated records, set the delimiter to merge corresponding unique values, and choose the function to calculate numbers. Or skip these steps in the future altogether by saving them into reusable 1-click scenarios.
Try it for 30 days for free
With Combine Duplicate Rows you will
- Combine rows with the same value Identify columns with duplicates and join corresponding unique records from other columns.
- Merge cells yet keep the data List unique related values using 1 of 4 built-in or your custom separators.
- Consider the text case of dupes Treat the same records written in different text cases as uniques.
- Consolidate rows in Google Sheets with 14 aggregate functions SUM, COUNT, COUNTA, AVERAGE, AVERAGEA, MIN, MAX, PRODUCT, MODE, STDEV, STDEVP, VAR, VARP, MEDIAN.
- Combine duplicates automatically using scenarios Save all settings into scenarios to use them later on the same or any other dataset.
- Synchronize actions for multiple columns Apply the same merging options to all or several columns automatically.
How to combine duplicates from several Google Sheets rows into one
Ablebits Docs
Have a look at online help pagesLicense benefits
Our customers get
30-day money-back guarantee
Frequently asked questions
What is Combine Duplicate Rows and what do I need it for?
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.
Doesn't Google provide a free way to merge duplicates in Google Sheets?
It does equip you with a couple of functions like UNIQUE, FIND, and QUERY. But if you're not familiar with them, you'll have to spend time over the tutorials to mix them together and build working formulas.
Our add-on is simple and intuitive and lets you combine duplicate rows in Google Sheets in a matter of seconds.
How to combine duplicate rows in Google Sheets?
Run Combine duplicate rows from the Dedupe & Compare or Merge & Combine group in Power Tools and follow these steps:
- Select the necessary data range.
- Pick key column(s) with duplicate records.
- Choose the columns to deduplicate and either:
- Merge unique values using delimiters.
- Or calculate numbers with the help of some functions.
- Hit Finish.
- Click Save scenario to keep this set of options for future use.
See a more detailed description here.
Will those scenarios help me combine duplicates automatically?
Yes! Scenarios were introduced for this exact purpose :)
If you regularly combine duplicates in Google Sheets, you can save the steps into scenarios. This will let you kickstart the add-on by simply running the scenario from the spreadsheet menu.
See a more detailed description here.
What are those "key columns with duplicate records"?
Your table may contain multiple columns with duplicates, 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.
What delimiters do you offer to merge unique records?
You can pick from 4 built-in delimiters: comma, semicolon, space, and line break.
But you are free to enter any other delimiter you'd like to see.
What functions do you use to calculate numbers if I decide to consolidate rows?
The add-on offers 14 functions to process your data: SUM, COUNT, COUNTA, AVERAGE, AVERAGEA, MIN, MAX, PRODUCT, MODE, STDEV, STDEVP, VAR, VARP, MEDIAN.
Can I use any or all these formulas for text strings somehow?
Only COUNTA. It counts the number of occurred records, i.e. ordered products, instead of listing their names.
I have lots of columns to merge. Am I to select the way to join for each column?
Not at all. If you'd like to join them in the same way, you can synchronize the action for all columns with a special option.
How does your tool manage empty cells?
It's entirely up to you. We've prepared the options to ignore empty cells in both key and additional columns.
System requirements
Operating Systems- Windows: Windows 10 and up
- Mac: macOS Catalina 10.15.7 and up
- Chrome OS™
Browsers- Chrome™
- Firefox
- Safari (Mac only)
30-day fully functional version
