nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

622705_en-US

liliconcom

Delete Duplicate Rows Based on Matching Cells

Hello,

I would like to request a function to be added to the Rows menu to delete duplicate rows based on a matching cell except for the first (or selected) one. Currently, one has to first select matching cells, unselect the first occurence, and then delete the remaining. In a large dataset with several unique sets of duplicates, this can be extremely cumbersome.

Thanks and regards

Mehul Shroff

Data Blending and Cleanup

Re: Delete Duplicate Rows Based on Matching Cells - Status changed to: Needs Info

Hi @MShroff there is a "select duplicate rows" option that operates on selected columns. Does this help?

Re: Delete Duplicate Rows Based on Matching Cells

Not quite - the process to select and delete duplicate rows (esp. when there are multiple sets of duplicates) is quite cumbersome.

Re: Delete Duplicate Rows Based on Matching Cells

Can you please say more?

Re: Delete Duplicate Rows Based on Matching Cells

1) select matching cells

2) create linked subset

3) select duplicates

4) delete

step 1 and 2 can be skipped if any duplicates have to be deleted - and not just duplicates of the selected rows.

Comments

There are no comments yet