Combine duplicate rows in Google Sheets

Combine duplicate rows in Google Sheets

Ian Lv7
  2024-08-29 20:15:08 2024-08-29 20:15:08 Created   2024-11-12 17:03:16 2024-11-12 17:03:16 Updated    

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.

Buy license

Choose your plan

This add-on is part of Power Tools: 30+ tools to boost your Google Sheets

Download

Try it 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

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

Also read:

  • Title: Combine duplicate rows in Google Sheets
  • Author: Ian
  • Created at : 2024-08-29 20:15:08
  • Updated at : 2024-11-12 17:03:16
  • Link: https://tools.techidaily.com/ablebits/google-sheets-add-ons-combine-duplicate-rows/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Combine duplicate rows in Google Sheets
  1. Buy license
  2. Download
  3. With Combine Duplicate Rows you will
    1. How to combine duplicates from several Google Sheets rows into one
  4. License benefits
    1. Our customers get