deleting/retaining duplicates
 

I have a spreadsheet with 2 sets of information. I need to be able to filter
it so that if there is a duplicate, the 1st set stays and the 2nd set is
deleted. If there is no duplicate, the 2nd set will still be displayed. I
have tried a couple things but no success yet. Anything I could try?

Thanks