Forum Discussion

azmatkhan's avatar
azmatkhan
New Member
4 years ago
Solved

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. 

2 Replies