The following approach can be helpful while showing multiple columns(‘,’ seperated) in a single row of a grid for a particular value.
--Column for which you need ',' seperated values
State = substring(EL.ORDER_list, 1, datalength(EL.ORDER_list)/2 - 1)
from Table1 c
(select state + ',' as [text()]
FOR XML PATH(''))