title: Convert Rows to Columns in SQL Server Query
body: <p>I am getting 5 rows against an SQL query, data screenshot is given below:</p>
  
  <p><img src="https://i.stack.imgur.com/EENtY.png" alt="enter image description here"></p>
  
  <p>I need to write SQL query which will convert these rows to 5 Cols. The result should be like this:</p>
  
  <pre><code>Col1 ---&gt; Value of First Row
  
  Col2 ---&gt; Value of Second Row
  
  Col3 ---&gt; Value of Third Row
  
  Col4 ---&gt; Value of Fourth Row
  
  Col5 ---&gt; Value of Fifth Row
  </code></pre>
  
  <p>Any help would be appreciated. Thanks!</p>