Hi there,
My name is Jerome. I would appreciate your help with the following problem.
I have an excel sheet whcih contains data displayed in various levels. There
are 11 levels in total. There are over 5000 rows. However each level has
different categories. I have to add the values of level 2 in level 1 and all
the values of level 3 into 2 and so forth. See tteh format below.
You'll notice that I have to add (PAYMENTS, TRANSFERS AND SUBSIDIES,
PAYMENTS FOR CAPITAL ASSETS - which are in level 2 ) in level 1 (PAYMENTS)
I should do the same for (TAX RECEIPTS, SALES GOODS & SERV NON CAP ASS,
TRANSFERS RECEIVED, FINES, PENALTIES AND FORFEITS, INTEREST, DIVIDEND, RENT
ON LAND, SALES OF CAPITAL ASSETS) and add it in level 1 (RECEIPTS)
LEVEL CODE AMOUNT 1 2
1 96623 PAYMENTS
2 982623 PAYMENTS
2 988623 TRANSFERS AND SUBSIDIES
2 996623 PAYMENTS FOR CAPITAL ASSETS
1 6318623 DIRECT EXCHEQUER PAYMENTS
2 6319623 DIRECT EXCHEQUER PAYMENTS
1 1623 RECEIPTS
2 2623 TAX RECEIPTS
2 3623 SALES GOODS & SERV NON CAP ASS
2 40623 TRANSFERS RECEIVED:
2 65623 FINES, PENALTIES AND FORFEITS
2 72623 INTEREST, DIVIDEND, RENT ON LAND
2 102623 SALES OF CAPITAL ASSETS
I have to do this for the entire worksheet. Could you please advise me how I
should go about this.
Thank you very much!:O)
Best regards,
Jerome