microsoft excel - Keep only one copy of the duplicated data

I am trying to clear out a list of content that appears 2,3,4 or more times repeatedly.

I have two columns and I would like to eliminate the whole row of any repeatedly entry of column B.

My current sheet can be shown here:

and after the needed trick, it should be shown like this:

Please advise.