Hi, try this: (Note that Table_1 is your table name.)
SELECT
DISTINCT r.no,
STUFF((SELECT DISTINCT ','+ a.name
FROM Table_1 a
WHERE r.no = a.no
FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, '')
FROM Table_1 r
I tried it by myself, and it's working.