Help for this page

Select Code to Download

Select or download this

SELECT Group, GROUP_CONCAT(SomeData ORDER BY SomeData SEPARATOR ',')
FROM table
GROUP BY `Group`

Select or download this

green       3,9
orange      8
purple      4
red         1,5,6,7
yellow      2