title: Multiple records represented as columns in query
body: <p>in Access I have two tables, tblID where with a field fName and tblDiagnoses and field fDgCode. Each fName can have multiple fDgCodes, which are unique.
  If I make a query I get a result like this</p>
  
  <pre><code>Mike ...  222
  Mike ...  344
  Mike ...  345
  John ...  234
  Peter ... 210
  Peter ... 222
  </code></pre>
  
  <p>How could I get this in one line, each entry in the second table as a separate column in my query or excel table-</p>
  
  <pre><code>A         B   C   D
  Mike ... 222 344 345
  John ... 234
  Peter .. 210 222
  </code></pre>