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
Learn more
This tool is part of
Power Tools
This add-on is part of Power Tools: 30+ tools to boost your Google Sheets
Сombine Rows add-on for Google Sheets

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

Select the range with your data
Select the range with your data
Tick the columns with duplicate records…
Tick the columns with duplicate records…
…and either join related records using delimiters or consolidate numbers with 14 aggregate functions
…and either join related records using delimiters or consolidate numbers with 14 aggregate functions
The resulting message will prompt what has been processed
The resulting message will prompt what has been processed
Merge duplicates automatically by saving your steps into scenarios.
Merge duplicates automatically by saving your steps into scenarios.
Start the scenario quickly from the Extensions menu
Start the scenario quickly from the Extensions menu
Merge records from dupe rows and calculate numbers in 14 ways.
Merge records from dupe rows and calculate numbers in 14 ways.

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

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:

  1. Select the necessary data range.
  2. Pick key column(s) with duplicate records.
  3. Choose the columns to deduplicate and either:
    • Merge unique values using delimiters.
    • Or calculate numbers with the help of some functions.
  4. Hit Finish.
  5. 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

  • Microsoft: Windows 7 and up
  • Mac: High Sierra 10.13 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)
Try it for free
This add-on is part of Power Tools: 30+ tools to boost your Google Sheets

30-day fully functional version