title: How to merge multiple rows of single column in SQL Server 2005?
body: <p>I get a output as shown in below table from my query as </p>
  
  <p><img src="https://i.stack.imgur.com/GRHK5.jpg" alt="enter image description here"></p>
  
  <p>Now I need my output should something like below table</p>
  
  <p><img src="https://i.stack.imgur.com/OlfOV.jpg" alt="enter image description here"></p>
  
  <p>It will merge the common fields of multiple rows into one cell.</p>
  
  <p>How can I write a query to do this?</p>