title: Pivot table in MySQL - convert to pivot table with values in varchar format
body: <p>i would like convert data from Table1 as you can see on first picture on data in Pivot_table. Is possible to do that in MySQL? Because the values of pivot table(A, B, C, D) are in varchar data format and i cannot use any aggregation function of MySQL like SUM or others.</p>
  
  <pre><code>Table1:
  PK        Name     Subject     Grade
  -------------------------------------
  1         Bob       Math        A
  2         Bob       History     B
  3         Bob       Language    C
  4         Bob       Biology     D
  5         Sue       History     C
  6         Sue       Math        A
  7         Sue       Music       A
  8         Sue       Geography   C
  
  
  Pivot_table:
  Subject     Bob     Sue
  -------------------------
  Math        A        A
  History     B        C
  Language    C 
  Biology     D
  Music                A
  Geography            C
  </code></pre>
  
  <p>Thanks for your help</p>