DataStage Scenario - Problem11

Which stages are needed to achieve below output ??

Input :

col1,col2
1,1
2,rajesh
3,15000
4,2
5,suresh
6,16000
7,3
8,veeru
9,17000 



Output

col1,col2,col3
1,rajesh,15000
2,suresh,16000
3,veeru,17000