Deduping where a single field is different

Question

I have a dataset which looks a bit like the below:

ABCDEAB DEFG IJFGHIJKL NOPQ ST

So occasionally a row has been duplicated where a single field has both a value and is empty. I would like to remove the rows where the exact same row exists but with data in the 3rd column and keep the row if this is not the case. i.e. make the above look like the below:

ABCDEFGHIJKL NOPQ ST

How could I go about doing this?

Thanks

jasperlch · Accepted Answer

Hi, I think the combination of Tile, Summarise and Filter tools will do the job: