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 14 most common AutoSum functions will calculate numbers for duplicate key records.
  • 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 AutoSum functions
…and either merge corresponding values using delimiters or consolidate numbers with 14 AutoSum 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 AutoSum 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

About Combine Rows for Google Sheets

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