I have a table imported from Access as follows:
CITY..........SURNAME........VALUE
London..........Jones.............30
London..........Aria................20
Newcastle......Aria................10
London..........Hendry............50
Newcastle......Harrison..........50
Manchester....Gio.................30

I would like to display a unique list of SURNAME based on CITY.
For Example:
If A2 in a spreadsheet says "London"
Show dynamically in Cell B5, B6 and B7 horizontally, the values "Jones", "Aria" and "Hendry"

If A2 in a spreadsheet says "Newcastle"
Show dynamically in Cell B5 and B6 horizontally, the values "Aria" and "Harrison"

If A2 in a spreadsheet says "Manchester"
Show dynamically in Cell B7 horizontally, the values "Gio"

If A2 in a spreadsheet says "TEST"
Show dynamically in Cell B5 horizontally, nothing.

How can I achieve this in Excel 2010? Any help is greatly appreciated.