title: Long to wide - SQL
body: <p>I have a table that is long (for example)</p>
  
  <pre><code>    Date        Person    Number
      2015-01-03  A         4
      2015-01-04  A         2
      2015-01-05  A         3
      2015-01-03  B         5
      2015-01-04  B         6
      2015-01-05  B         7
      2015-01-03  C         1
      2015-01-04  C         3
      2015-01-05  C         4
      2015-01-05  D         4
      2015-01-04  E         1
      2015-01-05  E         3
  </code></pre>
  
  <p>And I need it to look like (wide):</p>
  
  <pre><code>    Date          A    B    C    D    E
      2015-01-03    4    5    1    0    0
      2015-01-04    2    6    3    0    1
      2015-01-05    3    7    4    4    3
  </code></pre>
  
  <p>Any help would be much appreciated. I am using Transact. Thanks.</p>