title: Row Types into Columns with adjacent values into rows
body: <p>I have a long query which I'll summarize like:</p>
  
  <pre><code>SELECT Name, Type, Rev
  From Table
  </code></pre>
  
  <p>It returns something like:</p>
  
  <pre><code>Name    Type    Checked
  Bob     Grp1    Frank
  Bob     Grp2    Frank
  Bob     Grp3    Frank
  Lisa    Grp1    Sarah
  Lisa    Grp3    Sarah
  </code></pre>
  
  <p>Now, since I have up to 3 types, I'd like them to be their own columns and see the values in the 3rd column show up under each type:</p>
  
  <p>For example:</p>
  
  <pre><code>Name   Grp1    Grp2    Grp3 
  Bob    Frank   Frank   Frank
  Lisa   Sarah   NULL    Sarah
  </code></pre>
  
  <p>Basically I'm looking for a query on how to do this. Any feedback would be appreciated.</p>