title: Datastage: Split multiple sequential rows under different columns
body: <p>I've got this type of data in my Database. Imagine that <code>File_Name</code> is the column name and so I need to take all the rows (Under <code>"File_name"</code>) and put them into different columns with different Names.  <br/></p>
  
  <p><strong>File_Name</strong> (Column Name) <br/>
  <strong>File1</strong>  (First Row)<br/>
  <strong>File2</strong> (Second Row)<br/>
  <strong>File3</strong> (Third Row)<br/></p>
  
  <p>And I need to put them in another file like this:<br/> <br/> 
  <strong>File_Name1</strong> (Column Name1) ,<strong>File_Name2</strong> (Column Name2), <strong>File_Name3</strong> (Column Name3)<br/>
  <strong>File1</strong> (Under First column), <strong>File2</strong> (Under Second Column), <strong>File3</strong> (Under Third column)</p>
  
  <p>Is there a stage that can help me? I tried using the Pivot but I can't really figure how to set it with just one input column. </p>