title: How to transpose columns to rows in sql server
body: <p>I'm trying to take a raw data set that adds columns for new data and convert it to a more traditional table structure. The idea is to have the script pull the column name (the date) and put that into a new column and then stack each dates data values on top of each other.</p>
  
  <p>Example</p>
  
  <pre><code>Store     1/1/2013     2/1/2013
  XYZ INC   $1000        $2000
  </code></pre>
  
  <p>To</p>
  
  <pre><code>Store     Date         Value
  XYZ INC   1/1/2013     $1000
  XYZ INC   2/1/2013     $2000
  </code></pre>
  
  <p>thanks</p>