Combining data in different rows?

I would like to combine data from different rows in one column into
one row.

I have two tables: 'locations' containing a dozen records about
cities and their geographic coodinates - the other table,'testators',
contains several hundred records referring to wills (each will is
given a unique number) made by people in each of the towns in the
locations table.

I would like to query both tables so that a table is produced that
has one row for each of the dozen cities and in each row is the name
of the city, its coordinates and then a column containing all of the
wills (i.e. the unique identifying number of each) from that city.

Is this possible and if so, how?

Thanks!
-- Anthony Masinton