Remove duplicates in one column based on values in another column

Solution 1:

As suggested by Scott the remove duplicates functionality should work for you. If your case is different then you may have to state your problem clearly.