Remove duplicates based on a condition in other columns

[azmatkhan]

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. 

[v-yingjl · Accepted solution]

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.

[smpa01]

@azmatkhan  provide sample data and expected output

How-to-Get-Your-Question-Answered-Quickly