Question

How do you find duplicate rows and merge with combined values using Google Form and Sheets?

I am using Google Forms and one user entered the same job number multiple times. I want to combine the cells associated with those job numbers into a final value/summary. Does anyone have a recommendation?

Share
maguay's avatar
3 months ago

Google Sheets does include a built-in deduplication tool. In the Data menu, click Remove Duplicates to remove duplicated items. It works great with single columns of data; can be difficult to use with larger sheets. Otherwise, the Ablebits Google Sheets add-on "Remove duplicates" can be a good advanced option if you need—and it does have merge tools available as well.

3 points
akantjas's avatar
3 months ago

I have not looked at it on Google Sheets but I would know how to do it with Airtable.

There might be a simpler way in Sheets, what I would do is write a function in Google Scripts that deduplicates records.

Maybe Sheets has a deduplicate add-on. Have you searched for this?

2 points
What's the best to-do list app in 2021?

When you've got too many things to do, how do you keep track of them all? Have you started using a new to-do list app recently, or found an old one is still doing the job well? The last time we di...

The community for power users.