title: Need to transform pivot table into another format
body: <p>I want to find some way to change the pivot table back to normal table.</p>
  
  <p>Table 1 has following format:</p>
  
  <pre><code>acct type Hr08_C Hr09_C Hr10_C Hr08_H Hr09_H Hr10_H
   1    1     2      3      4      5      6       7
  </code></pre>
  
  <p>Table 2 has following format:</p>
  
  <pre><code>acct type hour phone value
    1   1     8    C     2
    1   1     9    C     3
    1   1     10   C     3
    1   1     8    H     5
    1   1     9    H     6
    1   1     10   H     7
  </code></pre>
  
  <p>I want to change the table 1 to table 2 format. Any idea about the query, please?</p>