title: How do i transform rows into columns in sql server 2005
body: <p>There is a <a href="https://stackoverflow.com/questions/655197/converting-rows-into-columns-in-t-sql-sql-server-2005">question</a> here in stackoverflow with the same title but that is not what I am looking for.<br>
  I have a table like the one below  </p>
  
  <pre><code>Name   | Count  
  ----------------    
  Chery  | 257  
  Drew   | 1500
  Morgon | 13  
  Kath   | 500  
  Kirk   | 200  
  Matt   | 76 
  </code></pre>
  
  <p>I need to trasform this result set into something like this  </p>
  
  <pre><code>Chery | Drew | Morgon | Kath | Kirk | Matt  
  -------------------------------------------  
  257     1500     13      500    200    76
  </code></pre>
  
  <p>How do i acheive this using sql server 2005?</p>