title: Transposing rows to columns in MsAccess query
body: <p>I have a table with </p>
  
  <blockquote>
    <p>cID, side, row, column</p>
  </blockquote>
  
  <p>with some data of</p>
  
  <pre><code>24, 1, 10, 5
  25, 1, 12, 6
  24, 2, 18, 3
  </code></pre>
  
  <p>and so on. Now I want these data to be show in the form of:</p>
  
  <pre><code>cID=24
  side    1   2
  row    10  18
  column  5   3
  
  cID=25
  side     2
  row     12
  column   6
  </code></pre>
  
  <p>The cID is filtered in the query so the output will be the 3 rows (side, row, column) and the data of them of a specific cID.
  Is that possible with MsAccess Query/SQL and how?</p>
  
  <p>Thanks!</p>