title: SQL Server 2008 pivot without aggregate
body: <p>I have table to test score data that I need to pivot and I am stuck on how to do it.</p>
  
  <p>I have the data as this:</p>
  
  <pre><code>gradelistening speaking reading writing
  0   0.0   0.0   0.0   0.0
  1 399.4 423.8   0.0   0.0
  2 461.6 508.4 424.2 431.5
  3 501.0 525.9 492.8 491.3
  4 521.9 517.4 488.7 486.7
  5 555.1 581.1 547.2 538.2
  6 562.7 545.5 498.2 530.2
  7 560.5 525.8 545.3 562.0
  8 580.9 548.7 551.4 560.3
  9 602.4 550.2 586.8 564.1
  10 623.4 581.1 589.9 568.5
  11 633.3 578.3 598.1 568.2
  12 626.0 588.8 600.5 564.8
  </code></pre>
  
  <p>But I need it like this:</p>
  
  <pre><code>  gr0 gr1 gr2 gr3 gr4 gr5 gr6 gr7 ...
  listening 0.0 399.4 461.6 501.0 521.9 555.1 562.7 560.5 580.9...
  speaking 0.0 423.8...
  reading 0.0 0.0 424.2...
  writing 0.0 0.0 431.5...
  </code></pre>
  
  <p>I don't need to aggregate anything, just pivot the data.</p>