Match function--two columns with duplicates, link together?

[zeppelinfan]

Hey guys, this is very basic so I don't think I need to upload, but can't figure out from googling. I have three columns to deal with, A and B are lists of countries and territories, and C is GDP data on column B.
I want to get a list where I have the C values correspond to A by matching the B and A values while also moving C with B.

For example:
Column C is the data for the countries in B (arbitrary numbers).
A ___________ B________C
USA_______France_____1000
Germany___USA_______700
Poland_____China______800
Japan_____Germany____900
Finland_____Estonia____1000
France_____Poland_____700
Estonia
St. Lucia

How do I match same values of column B to column A while also making the corresponding values for C move with B? To look maybe like this:

A_________B_________C
USA______USA_______700
Germany__Germany___900
Poland____Poland_____700
Japan
Finland
France____France_____1000
St. Lucia
China_____China______800


Thanks very much guys. Sorry if this is bad formatting, I am new to this forum, but since this is the beginner one I hope it will be okay.

[JBeaucaire]

'LINE UP DATA
Here's a macro for matching rows of data or groups of data by key values in each group.

LINE UP MATCHES - LineEmUp.xls

The sample workbook on that page can be used for your project. I think LineEmUp4 is the one for you to use, just insert a blank column between your A and B so both sets can be considered "two-column" data. After you run the macro and it aligns all the values for you, you can delete that empty column B again.

[zeppelinfan]

Thanks a lot. This worked!

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.