WITH cteData (ID, Colors) AS
(SELECT	1, 'Blue'
UNION
SELECT	2, 'Red'
UNION
SELECT	3, 'Yellow'
UNION
SELECT	4, 'Gray'
UNION
SELECT	1, 'Purple'
UNION
SELECT	2, 'Orange'
UNION
SELECT	3, 'Green'
UNION
SELECT	4, 'Black & White')

SELECT	REPLACE(STUFF((SELECT ', ' + d.Colors
			FROM [cteData] d
			WHERE c.[ID] = d.[ID]
			ORDER BY [d].[Colors]
			FOR XML PATH('')),1,1,''), '&*amp*;', '&') [ColorList]
FROM	[cteData] c
GROUP BY c.[ID]
ORDER BY c.[ID]