title: SQL to transpose row pairs to columns in MS ACCESS database
body: <p>I have an MS Access database that contains translated sentences in source-target pairs (a translation memory for fellow users of CAT tools). Somewhat annoyingly, source and target are not stored in separate columns, but in rows linked by ID, like this:</p>
  
  <pre><code>+---+----+--------------+
  |id |lang|    text      |
  +---+----+--------------+
    1   a     lang a text
    1   b     lang b text 
    2   a     more a text...
    2   b     more b text...
  +---+----+--------------+
  </code></pre>
  
  <p>What SQL could I use to turn that into a table such as:</p>
  
  <pre><code>+---+--------------+--------------+
  |id | lang A       | lang B       |
  +---+--------------+--------------+
   1   lang a text    lang b text
   2   more a text... more b text...
  </code></pre>
  
  <p>Performance doesn't matter here, since would I only need to do this once in a while, and the db isn't huge (only a few thousand rows).</p>