Forum Discussion
azmatkhan
4 years agoNew Member
Remove duplicates based on a condition in other columns
My data contains duplicates but there is a some difference in the data in the duplicate rows. I want to remove only selected rows based on the data in selected columns. eg. Column A is "reporting district" and Column B is "resident district" and so on. All these columns are the same in the duplicate data but Column X to Column Z are different in that these columns are blank in one row and filled in other. Now I want to remove the row that is blank and keep the one that is filled.
Hi azmatkhan ,
Have created a table like this:
Set the filter condition:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.