title: Need to Split Date Column into Multiple Columns by year
body: <p>I'm trying to split a date column into multiple columns by year.  If I could achieve a roll-up subtotal at the end that would be awesome.</p>
  
  <p>I'm thinking the best way to do it, is using a .NET datalist control, but I'm open to suggestions.</p>
  
  <p>Example data:</p>
  
  <pre><code>DATE     | SALES
  1/1/2009 | 1234.56
  2/1/2009 | 4567.89
  3/1/2009 | 7890.12
  ...
  1/1/2010 | 3456.78
  ...
  1/1/2011 | 8901.23
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>       2009     2010     2011
  Jan    1234.56  3456.78  8901.23
  Feb    4567.89  ...
  </code></pre>
  
  <p>Thanks in advance!</p>