title: Grouping similar values into new select statement
body: <p>I have a table which looks something like this...</p>
  
  <pre><code>supplier_name  status       count 
  supplier_a     Unavailable  1
  supplier_a     Refunded     5
  supplier_a     Shipped      10
  supplier_z     Refunded     2
  supplier_z     Shipped      4
  </code></pre>
  
  <p>I know exactly what columns I want and I would like to use the values from the first table to return values structured like the following...</p>
  
  <pre><code>supplier_name   unavailable   refunded   shipped
  supplier_a      1             5          10
  supplier_z      0             2          4
  </code></pre>
  
  <p>(note: in cases where there is no value for a specific column it should be set to 0)</p>
  
  <p>Would this be possible to achieve in a query?</p>