title: Transposing Dynamic Columns to Rows
body: <p>I'd like to know how to unpivot <code>Table_1</code> into <code>Expected_Result_Table</code>:</p>
  
  <pre><code>Table1
  -----------------------------------------
  Id       abc  brt ccc ddq eee fff gga hxx
  -----------------------------------------
  12345     0    1   0   5   0   2   0   0  
  21321     0    0   0   0   0   0   0   0   
  33333     2    0   0   0   0   0   0   0   
  41414     0    0   0   0   5   0   0   1   
  55001     0    0   0   0   0   0   0   2   
  60000     0    0   0   0   0   0   0   0 
  77777     9    0   3   0   0   0   0   0
  </code></pre>
  
  
  
  <pre><code>Expected_Result_Table
  ---------------------
  Id      Word   Qty&gt;0
  ---------------------
  12345    brt    1
  12345    ddq    5
  12345    fff    2
  33333    abc    2
  41414    eee    5
  41414    hxx    1
  55001    hxx    2
  77777    abc    9
  77777    ccc    3
  </code></pre>
  
  <p>So, How to transpose columns in <code>Table_1</code> resulting in <code>Expected_Result_Table</code>, considering only values > 0?</p>