Convert multiple columns into a single column separated by comma

If you are on 2017 or later you can use CONCAT_WS:

Select Id
     , name
     , concat_ws(',', Mon, Tue, Wed, Thu, Fri, Sat, Sun)
  From employee
1 Like