Combine duplicate rows in Google Sheets
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
- 12-month access with all updates $29.99
- Lifetime - Get all new features and updates for free ever! $99.95
Download
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
Tick the columns with duplicate records…
…and either join related records using delimiters or consolidate numbers with 14 aggregate functions
The resulting message will prompt what has been processed
Merge duplicates automatically by saving your steps into scenarios.
Start the scenario quickly from the Extensions menu
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-10-17 11:31:26
- 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.