Deduping where a single field is different

[JonnyR]

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

A	B	C	D	E
A	B		D	E
F	G		I	J
F	G	H	I	J
K	L		N	O
P	Q		S	T

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:

A	B	C	D	E
F	G	H	I	J
K	L		N	O
P	Q		S	T

How could I go about doing this?

Thanks

[AdamR_AYX]

I'd use a summarise and group on fields 1,2,4 and 5 and then choose either First for column 3 or maybe Concat depending on the actual data.

[jasperlch · Accepted solution]

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