title: Sorting a table into a another table
body: <p>I'm sorry for the vague title, I don't know how to classify this issue. An example of my problem is below.
  I'm trying to get this:</p>
  
  <pre><code>   A         B        C
  Ammonia     21.4     12-1-15
  Ammonia     21       12-2-15
  Nitrate     0.25     12-1-15
  Nitrate     0.25     12-2-15
  TKN          1       12-1-15
  TKN          2       12-2-15
  </code></pre>
  
  <p>Into something like this without always copying it ( there's a ton of data and references)</p>
  
  <pre><code>       Date     Ammonia     Nitrate      TKN
      12-1-15     21.4         0.25        1
      12-2-15     21           0.25        2
  </code></pre>
  
  <p>Hopefully without the use of vba.</p>