DSXchange

Hi All,

can any one please help me to solve the below query.

source:
empno, Sal
101,1000
101,2000
101,3000
102,1000
102,2000
102,3000

output:
empno,sal
101,1000
101,10002000
101,100020003000
102,1000
102,10002000
102,100020003000

Thanks In advance.

Search for "vertical pivot" and adapt one of the techniques.