NAME   PROFESSION ADDRESS ... (+ CartoDb fields like cartodb_id, the_geom_webmercator)
Smith  shopkeeker grand-rue 10
Martin baker      grand-rue 11
Wagner grocery    grand-rue 11

SELECT  address, string_agg(name || ', ' || profession, '; ' ORDER BY name, profession) FROM table_name group by address

SELECT  address, string_agg(name || ', ' || profession, '; ' ORDER BY name, profession), the_geo_webmercator, cartodb_id FROM table_name group by address, the_geo_webmercator, cartodb_id

Grand-rue 11
Martin, baker; Wagner, grocery

Grand-rue 11
1. Martin
   baker
2. Wagner
   grocery

SELECT  address, string_agg(name || ', ' || profession, '; ' ORDER BY name, profession),
        the_geom_webmercator, Min(cartodb_id) cartodb_id
FROM table_name
group by address, the_geom_webmercator