title: Multiple rows transpose to one row with multiple columns
body: <p>I have an MS Access project and I want to make a report from a table. I am not pretty sure if this can be done.</p>
  
  <p>The following is the source table</p>
  
  <pre><code>Name    Fruits     Count
  Jorge   Apple       4
  Jorge   Mango       3
  Jorge   Pears       4
  Jorge   Pineapple   6
  James   Apple       8
  James   Mango       1
  James   Pears       4
  James   Pineapple   6
  </code></pre>
  
  <p>And I want a result like this in a continuous form </p>
  
  <pre><code>Name    Apple   Mango   Pears   Pineapple
  Jorge     4       3      4         6
  James     8       1      4         6
  </code></pre>
  
  <p>Any way an SQL can do this?</p>