Excel 2007 :: Remove Duplicates In Column B For Each Value In Column A?

I need to remove the duplicates under column B for each item under column A and I can't seem to figure out how to do it.

I'm using Excel 2007; I would prefer a VBA solution, as I have to do this on a monthly basis. However, if a formula is the best way to go, then that's just fine. Either way, I'm preparing the data for a pivot table. I am unable to post the actual document in the interest of data protection.

Essentially, I'd like to turn this-

_ A B
1 Paris Bill
2 Paris Bill
3 Paris Mike
4 Paris Derek
5 Paris Derek
6 London Mike
7 London Bill
8 London Mike
9 London Bill
10 London Derek
11 Tokyo Derek
12 Tokyo Derek
13 Tokyo Derek

into this-

_ A B
1 Paris Bill
2 Paris Mike
3 Paris Derek
4 London Mike
5 London Bill
6 London Derek
7 Tokyo Derek

In other words, each city should have only one instance of any name that accompanies it; not all names will accompany each city.