title: How can I convert a 2-D table into a grid in Excel or MS Access
body: <p>I have 3 tables:</p>
  <pre><code>Room A
  Room B
  Room C
  </code></pre>
  <pre><code>8:00
  9:00
  10:00
  11:00
  </code></pre>
  <pre><code>Kathy   Room A  9:00
  John    Room C  8:00
  DaVon   Room C  10:00
  Janelly Room A  10:00
  </code></pre>
  <p>I want to create a grid using Table A for Rows and Table B for Columns, like so:</p>
  <pre><code>        8:00    9:00    10:00    11:00
  Room A          Kathy   Janelly
  Room B
  Room C  John            DaVon
  </code></pre>
  <p>I'd prefer using the query designer if possible.</p>