I have a database with names and cities of persons (all in one table). Names can be the same, but if that's the case then he/she lives in another city (so the name AND city are the primary key).

How can I show the results of a query(DAO) in a dbgrid, so that if the name is the same they occupy one row in the grid instead for each double name a new row, so that you have a name and after the name, the city (next cell) with all the cities the name is present? for example:

NAME CITY
Johnson New York, Boston instead of:

NAME CITY
Johnson New York
Johnson Boston

Thnx in advance