Is it possible to transform a point shapefile in single part geometry to a shapefile with multi-point geometry based on an attribute. e.g. in the file are 50.000 records in 700 categories, now I want to create a multi-part geometry point file.
The result should be a shapefile with 700 records (=categories in the former shape).
Is this possible in QGIS, Spatialite or something else?