Group different rows in one by combining strings

 SELECT Column1, group_concat(Column2) FROM Table GROUP BY Column1

group_concat takes an optional second argument (a string) to use as the concatenation separator if you don’t want a single ‘,’ character.