hi my input is like
A/C NO Name Charg Type AMOUNT
50000009861 A ENERGY 100.00
50000009861 A FAC 10
50000009864 B ENERGY 200.00
50000009864 B FAC 20
and i want my output as
A/C NO...
Contract a/c Charge type Amount
700109234 ENERGY 59,885.00
700109234 RENT 968
700109234 TAX 1,210.00
700109235 ENERGY 5,670.00
700109235 RENT 231
700109235 TAX 75
FOR THIS I WANT OUPUT AS
contract a/c Energy Rent Tax...