My inputs are in this way :
col1 col2 col3 1 a c 1 b c 2 c c 2 d b 2 e z
And I would like to obtain :
col1 col2 1 a, b 2 c, d, e
I tried doing this using the virtual layer and in the query builder using array_agg function but QGIS doesn't seem to recognize this feature.
Ideally I would like to obtain this type of results however :
col1 col2 1 a:c, b:c 2 c:c, d:b, e:z