title: How to transform Rows into Column Sql Server
body: <p>How to transform Rows into Columns for the below table data in SQL serer</p>
  <blockquote>
  <p>Actual table</p>
  </blockquote>
  <pre><code>LabelID  |  LabelName
  ---------------------
      1    |  Label1
      2    |  Label2
      3    |  Label3
      4    |  Label4
      5    |  Label5
  </code></pre>
  <blockquote>
  <p>Expected table</p>
  </blockquote>
  <pre><code>    1  |    2   |   3   |   4    |  5   
  ------------------------------------------
  Label1 | Label2 | Labe3 | Label4 | Label15
  </code></pre>