title: Kettle PDI Concat column values
body: <p>I have a PDI (Kettle) <strong>transformation</strong> that execute an SQL script, the output of scripts is a column looks like:</p>
  
  <blockquote>
    <p>val1</p>
    
    <p>val2</p>
    
    <p>val3</p>
    
    <p>val4</p>
    
    <p>"more values"...</p>
  </blockquote>
  
  <p>I need write this on a only one Excel cell like this:</p>
  
  <blockquote>
    <p>val1 val2 val3 val4 "more values"...</p>
  </blockquote>
  
  <p>How i can do this?</p>
  
  <p>I tried "row denormaliser" and "row flattener" but dont work (i dont know why)</p>