Hi all. I have a spreadsheet which has a list of people's names and their associated location, for example:

First Name Last Name Location
Fred Bloggs London
Peter Parker London
Joe Bloggs Birmingham
John Smith Birmingham

What I want to do in Word is create a list of names for each location - so the end result would be:

London: Fred Bloggs, Peter Parker
Birmingham: Joe Bloggs, John Smith

Is there a way to do this please? Many thanks, Doug.