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

##</code><code>##

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