title: How to transpose row to multiple coloumn?
body: <p>Look, I have this as data in mySQL . The table name is "schedule"</p>
  
  <blockquote>
    <p>======================================================</p>
    
    <p>Mapel|Kelas|Tanggal| Nama| Status</p>
    
    <p>======================================================</p>
    
    <p>Bhs. Indo  || 1A || 2015-01-14 || Adi || x </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-14 || Ani || x </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-14 || Sisi || - </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-14 || Tara || - </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-14 || Wina || x </p>
    
    <p>Math   || 1A || 2015-01-15 || Adi || x </p>
    
    <p>Math  || 1A || 2015-01-15 || Ani || - </p>
    
    <p>Math  || 1A || 2015-01-15 || Sisi || - </p>
    
    <p>Math  || 1A || 2015-01-15 || Tara || - </p>
    
    <p>Math  || 1A || 2015-01-15 || Wina || x  </p>
    
    <p>Bhs. Indo   || 1A || 2015-01-15 || Adi || x </p>
    
    <p>Bhs. Indo   || 1A || 2015-01-15 || Ani || - </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-15 || Sisi || - </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-15 || Tara || - </p>
    
    <p>Bhs. Indo  || 1A || 2015-01-15 || Wina || x  </p>
  </blockquote>
  
  <p>Now I want to make a show a table depend on "MAPEL" and "KELAS"
  if I chose Mapel = 'Bhs. Indo' and KELAS = '1A' would show a table like this</p>
  
  <blockquote>
    <p>======================================================</p>
    
    <p>Kelas| Nama | 2015-01-14 | 2015-01-15 | </p>
    
    <p>======================================================</p>
    
    <p>1A || Adi || x  || x</p>
    
    <p>1A || Ani || x  || -</p>
    
    <p>1A || Sisi || - || -</p>
    
    <p>1A ||Tara || -  || -</p>
    
    <p>1A || Wina || x || x</p>
  </blockquote>