title: Converting Row Columns to Rows with Pentaho Kettle/PDI
body: <p>Brand new to Pentaho (and a newbie SO poster so look out!) </p>
  
  <p>I'd like to use Kettle/PDI to transform data coming in from an RDBMS from this (for example):</p>
  
  <pre>
  Question1   Question2   Question3   Question4
  1/1/13      123.00      Test 1      Test 1.1
  1/2/13      124.00      Test 2      Test 1.2
  1/3/13      125.00      Test 3      Test 1.3
  1/4/13      126.00      Test 4      Test 1.4
  1/5/13      127.00      Test 5      Test 1.5
  </pre>
  
  <p>to this:</p>
  
  <pre>
  QuestionName AnswerDate AnswerNumber AnswerString
  Question1    1/1/13     
  Question1    1/2/13     
  Question1    1/3/13     
  Question1    1/4/13     
  Question1    1/5/13     
  Question2               123.00
  Question2               124.00
  Question2               125.00
  Question2               126.00
  Question2               127.00
  Question3                             Test 1
  Question3                             Test 2
  Question3                             Test 3
  Question3                             Test 4
  Question3                             Test 5
  Question4                             Test 1.1
  Question4                             Test 1.2
  Question4                             Test 1.3
  Question4                             Test 1.4
  Question4                             Test 1.5
  </pre>
  
  <p>As hopefully reflected above, there should be an "Answer&lt;FieldDataType&gt;" column for each available datatype in the original table.  Is this possible with PDI?  If so, can someone provide me with some pointers?  I've tried using the <a href="http://wiki.pentaho.com/display/EAI/Row+Normalizer" rel="noreferrer">Row Normaliser</a> step to pivot the table and assign the new fields, but am probably not doing things quite right (or there is a bug [PDI 4.4]).</p>