Data cleanup based on variable conditions

[Busamancan]

I have a data dump from a system that I do daily and I am looking for a way to automate the elimination of data I don't want. Attached is a data sample and end result I am looking for with specific notes.

thx,
Busa

[oeldere]

Make a table of your data
Insert => table.

I2 =A2&F2
J2 =IF(COUNTIF($I$2:$I2,$I2)=$F2,"yes","")

After that filter on column J and select for "" (empty).

Delete the filtered data.

After that you get the result you posted.

See the attached file.