I hope this may help you

be careful with string limit,null values, implicit conversions about string agg function

use string_agg and concat function

sample

SELECT STRING_AGG(CONCAT_WS('_',ColumnA,ColumnB,ColumnC,ColumnD),',') as comment
  FROM TABLE1