Pivot table

[nasir]

Hello
I would like to create a pivot from this data

A B C D E F G H I J K L M N
1 Agency Fund Amount 0301-FUEL AUTOMOTIVE 0302-FUEL - HEATING 0303-FUEL - OTHER 0304-GAS 0305-ELECTRICITY 0306-STEAM 0307-WATER 0309-RENTALS - LAND AND STRUCTURES 0430-JANITORIAL SERVICES 0440-SECURITY SERVICES 0310-OCCUPANCY FIXED COSTS
2 AC0-OFFICE OF THE D.C. AUDITOR 0100-LOCAL FUND 307,113.40 31,629.82
3 AD0-OFFICE OF THE INSPECTOR GENERAL 0200-FEDERAL GRANT FUND 529.00 229,162.00 1,487.52
4 AM0-DEPARTMENT OF REAL ESTATE SERVICES 0600-SPECIAL PURPOSE REVENUE FUNDS 3,368.00 114,047.00 15,444.00 82,320.00
5 CB0-OFFICE OF THE ATTORNEY GENERAL 0100-LOCAL FUND 18,626.00 141.00 1,084.00 1,154,140.08 48,841.89 583,595.00 262,332.68 249,577.13 361,184.45
6 CB0-OFFICE OF THE ATTORNEY GENERAL 0200-FEDERAL GRANT FUND 78,954.62 5,313.24 58,459.30 77,103.87 117,451.52
7 CF0-DEPARTMENT OF EMPLOYMENT SERVICES 0200-FEDERAL GRANT FUND 8,542.00 18,761.00 170,174.00 34,909.00 1,736,170.00 112,315.00 156,286.00
8 CF0-DEPARTMENT OF EMPLOYMENT SERVICES 0600-SPECIAL PURPOSE REVENUE FUNDS 6,766.00 38,425.00 2,868,766.00 285,729.00
9 CT0-OFFICE OF CABLE TV 0600-SPECIAL PURPOSE REVENUE FUNDS 13,299.67 1,448,278.43
10 DB0-DEPT. OF HOUSING AND COMM. DEVELOPMENT 0200-FEDERAL GRANT FUND 6,277.00 189.00 1,134.00 757,374.00 2,538.00 4,610.00


Excel tables to the web >> Excel Jeanie HTML 4

I would like to show the above in the following format

Agency Fund Comp Object
AC0 0100 0301

ETC


Thanks

 

[nasir]

Fixed Cost Budget FY 2011 2011

A B C D E F G H I J K L M N
1 Agency Fund Amount 0301-FUEL AUTOMOTIVE 0302-FUEL - HEATING 0303-FUEL - OTHER 0304-GAS 0305-ELECTRICITY 0306-STEAM 0307-WATER 0309-RENTALS - LAND AND STRUCTURES 0430-JANITORIAL SERVICES 0440-SECURITY SERVICES 0310-OCCUPANCY FIXED COSTS
2 AC0-OFFICE OF THE D.C. AUDITOR 0100-LOCAL FUND 307,113.40 31,629.82
3 AD0-OFFICE OF THE INSPECTOR GENERAL 0200-FEDERAL GRANT FUND 529.00 229,162.00 1,487.52
4 AM0-DEPARTMENT OF REAL ESTATE SERVICES 0600-SPECIAL PURPOSE REVENUE FUNDS 3,368.00 114,047.00 15,444.00 82,320.00
5 CB0-OFFICE OF THE ATTORNEY GENERAL 0100-LOCAL FUND 18,626.00 141.00 1,084.00 1,154,140.08 48,841.89 583,595.00 262,332.68 249,577.13 361,184.45
6 CB0-OFFICE OF THE ATTORNEY GENERAL 0200-FEDERAL GRANT FUND 78,954.62 5,313.24 58,459.30 77,103.87 117,451.52
7 CF0-DEPARTMENT OF EMPLOYMENT SERVICES 0200-FEDERAL GRANT FUND 8,542.00 18,761.00 170,174.00 34,909.00 1,736,170.00 112,315.00 156,286.00
8 CF0-DEPARTMENT OF EMPLOYMENT SERVICES 0600-SPECIAL PURPOSE REVENUE FUNDS 6,766.00 38,425.00 2,868,766.00 285,729.00
9 CT0-OFFICE OF CABLE TV 0600-SPECIAL PURPOSE REVENUE FUNDS 13,299.67 1,448,278.43
10 DB0-DEPT. OF HOUSING AND COMM. DEVELOPMENT 0200-FEDERAL GRANT FUND 6,277.00 189.00 1,134.00 757,374.00 2,538.00 4,610.00


Excel tables to the web >> Excel Jeanie HTML 4