Here is my requirement: HAVE EMP ID SALARY1 SALARY2 QTY AB1001 100 101 1 AB1001 200 102 2 CD1002 100 101 1 CD1002 200 102 2 CD1002 300 103 3 EF1003 400 101 1 EF1003 500 102 2 GH1004 600 101 1 GH1004 700 102 2 GH1004 800 103 3 GH1004 900 104 4   WANT:     EMP ID SALARY1 SALARY2 QTY   AB1001 100 102 1   AB1001 200 101 2 New record AB1001 200 102 3   CD1002 100 101 1   CD1002 200 103 2   CD1002 300 102 3 New record CD1002 300 103 6   EF1003 500 101 1   EF1003 400 102 2 New record EF1003 500 102 3   GH1004 600 101 1   GH1004 700 102 2   GH1004 900 103 3   GH1004 800 104 4 New record GH1004 900 104 10 ... View more