Try this....

SELECT DISTINCT c1.Col1, c1.Col2,

STUFF((SELECT ',' + Col3 FROM Tablename c WHERE c.Col1 = c1.Col1 FOR XML PATH('')),1,1,'')

FROM Tablename c1