title: Rolling up multiple rows in single row
body: <p>I am trying to merge rows of employee DB table</p>
  
  <p>Here is my original table</p>
  
  <p><a href="https://i.stack.imgur.com/6YcbG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6YcbG.png" alt="enter image description here"></a></p>
  
  <p>I want to merge rows based on department. here is my expected result.</p>
  
  <p><a href="https://i.stack.imgur.com/u0boS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u0boS.png" alt="enter image description here"></a> </p>
  
  <p>I tried using  FOR XML PATH('')), 1, 1, '') but I canroll up only one column.</p>
  
  <p>I know we have similar question <a href="https://stackoverflow.com/questions/30604252/rolling-up-multiple-rows-into-single-row-using-2-tables">here</a> but its rolling up only one column.</p>
  
  <p>any help is much appreciated </p>