A/c numer with document no and its charges

[bekkems]

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 Name Energy Fac

50000009861 A 100 10

50000009864 B 200 20


please provide me the solution.


thanks in advance

bekkems

 

[asa]

Hi Bekkems,


Pivot table.

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one


See if that suits your needs... It can transform your data in the way you describe.


Asa