title: pentaho transpose n columns to one column
body: <p>I want to transpose n columns in inputfields to one column</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">firstname</th>
  <th style="text-align: center;">lastname</th>
  <th style="text-align: center;">subject1</th>
  <th>date1</th>
  <th>note1</th>
  <th>subject2</th>
  <th>date2</th>
  <th>note2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">joe</td>
  <td style="text-align: center;">joe</td>
  <td style="text-align: center;">Math</td>
  <td>-----</td>
  <td>15</td>
  <td>Phys</td>
  <td>-----</td>
  <td>10</td>
  </tr>
  <tr>
  <td style="text-align: left;">Judy</td>
  <td style="text-align: center;">judy</td>
  <td style="text-align: center;">Math</td>
  <td>-----</td>
  <td>12</td>
  <td>Phys</td>
  <td>-----</td>
  <td>16</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>to</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">firstname</th>
  <th style="text-align: center;">lastname</th>
  <th style="text-align: center;">subject</th>
  <th>date</th>
  <th>note</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">joe</td>
  <td style="text-align: center;">joe</td>
  <td style="text-align: center;">Math</td>
  <td>----</td>
  <td>15</td>
  </tr>
  <tr>
  <td style="text-align: left;">joe</td>
  <td style="text-align: center;">joe</td>
  <td style="text-align: center;">Phys</td>
  <td>----</td>
  <td>10</td>
  </tr>
  <tr>
  <td style="text-align: left;">Judy</td>
  <td style="text-align: center;">Judy</td>
  <td style="text-align: center;">Math</td>
  <td>----</td>
  <td>12</td>
  </tr>
  <tr>
  <td style="text-align: left;">Judy</td>
  <td style="text-align: center;">Judy</td>
  <td style="text-align: center;">Phys</td>
  <td>----</td>
  <td>16</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Someone knows how can I achieve this? Is there some step that could help or only through scripts?</p>