Deleting Duplicates-find out a way to delete duplicates

Hey,

I'm looking to find out a way to delete duplicates where there are 2 columns of information

I'm not sure of a clear way of explaining this in words, so here's a detailed explanation in a spreadsheet

Thank you for your time and efforts
Bob