As your are on unix, if the data is going to have a consistent number of rows each time (e.g. in your example always 3 rows to be turned into 3 columns), the unix "paste" command will achieve this. Try the commnad "man paste" for an explanation.
Read up on the Pivot Stage in your Ascential Documentation.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>