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 all corresponding values, and choose the function to calculate numbers.

Try it for 30 days for free
This add-on is part of
Power Tools
Сombine Rows add-on for Google Sheets

With Combine Rows you will

  • Combine rows with same value Identify columns with duplicates and join corresponding unique records from other columns.
  • Merge cells yet keep the data Pick one of 4 delimiters or enter yours to bring values together.
  • Consider case of duplicates Treat the same records written in different 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.
  • Synchronize action Apply the same merging options to all columns automatically.
  • Skip empty cells Consider only cells filled with data or include blanks to the result.

How to combine multiple rows into one based on duplicates

   
The add-on can be found in the Merge & Combine group of Power Tools
The add-on can be found in the Merge & Combine group of Power Tools
Click the Combine rows icon to run the tool
Click the Combine rows icon to run the tool
Select the range with your data
Select the range with your data
Tick of the columns that contain duplicate records…
Tick of the columns that contain duplicate records…
…and either merge corresponding values using delimiters or consolidate numbers with 14 summary functions
…and either merge corresponding values using delimiters or consolidate numbers with 14 summary functions
The result message will prompt what has been processed
The result message will prompt what has been processed
Get unique records for each duplicate entry arranged together on one row
Get unique records for each duplicate entry arranged together on one row
The add-on can be found in the Merge & Combine group of Power Tools
Click the Combine rows icon to run the tool
Select the range with your data
Tick of the columns that contain duplicate records…
…and either merge corresponding values using delimiters or consolidate numbers with 14 summary functions
The result message will prompt what has been processed
Get unique records for each duplicate entry arranged together on one row

License benefits

Our customers get

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

These companies choose Ablebits products

   

Frequently asked questions

What is Combine 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 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.

How to combine duplicate rows in Google Sheets?

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.

What are those "key columns with duplicate records"?

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.

What delimiters do you offer to separate merged values?

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.

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 textual records somehow?

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

I have lots of columns to merge. Am I select the way to combine for each column?

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.

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: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)
Try it for free

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close