title: Using PIVOT table with SQL Server 2008 R2
body: <p>I have come across an issue which I cannot resolve and have tried everything. Hope I can get an answer here.</p>
  
  <p>My data in my table is as follows</p>
  
  <pre><code>Id Month Val1 Val2 Val3
  1  Jan   70   80   90
  2  Jan   12   13   15
  3  Feb   12   67   99
  4  March 14   15   17.1
  </code></pre>
  
  <p>From the following structure I would like to pivot the data based on column <code>val1</code> so my output will look like:</p>
  
  <pre><code>Jan Jan Feb March
  70  12  12  14
  </code></pre>