title: grouping and switching the columns and rows
body: <p>I don't know if this would officially be called a pivot, but the result that I would like is this:</p>
  
  <pre><code>+------+---------+------+
  | Alex | Charley | Liza |
  +------+---------+------+
  |  213 |     345 |    1 |
  |   23 |     111 |    5 |
  |   42 |      52 |    2 |
  |  323 |         |    5 |
  |   23 |         |    1 |
  |  324 |         |    5 |
  +------+---------+------+
  </code></pre>
  
  <p>my input data is in this form:</p>
  
  <pre><code>+-----+---------+
  | Apt |  Name   |
  +-----+---------+
  | 213 | Alex    |
  |  23 | Alex    |
  |  42 | Alex    |
  | 323 | Alex    |
  |  23 | Alex    |
  | 324 | Alex    |
  | 345 | Charley |
  | 111 | Charley |
  |  52 | Charley |
  |   1 | Liza    |
  |   5 | Liza    |
  |   2 | Liza    |
  |   5 | Liza    |
  |   1 | Liza    |
  |   5 | Liza    |
  +-----+---------+
  </code></pre>
  
  <p>because I have approximately 100 names, I don't want to have to do a ton of sub queries lik this</p>
  
  <pre><code>select null, null, thirdcolumn from...
  select null, seconcolumn from...
  select firstcolumn from...
  </code></pre>
  
  <p>Is there a way to do this with <code>PIVOT</code> or otherwise?</p>