title: T-SQL - how to swap rows and columns
body: <p>I have a resultset structure like this</p>
  
  <pre><code>ID       Value      Name
  1       Oranges     Reponse
  1       42      Count
  2       Apples      Reponse
  2       65      Count
  3       Figs        Reponse
  3       74      Count
  </code></pre>
  
  <p>and I want to get to this:</p>
  
  <pre><code>ID     Response       Count
  1       Oranges     42
  2       Apples      65
  3       Figs        74 
  </code></pre>
  
  <p>using SQL.  Is there a way to do this?  thanks!</p>