title: mysql group to columns
body: <p>So i have to columns in my table one called spend and one save.</p>
  
  <p>what I would like to do is join the two so that is says offers and has the spend|save </p>
  
  <p>Say I have table as </p>
  
  <pre><code>spend    save
  30       10
  </code></pre>
  
  <p>Output I want is </p>
  
  <pre><code>spend    save   dummyCol
  30       10     30|10
  </code></pre>