Get column value by comma separated in sql

select distinct t.[user],
  STUFF((SELECT distinct ', ' + t1.department
         from yourtablename t1
         where t.[user] = t1.[user]
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,2,'') department
from yourtablename t;