Spreadsheet: 600810d1543960319-group-or-pivot-a-table-with-multiple-columns-which-share-one-description-field-excel-sample
Sheet: Sheet1

Fund Entity | Fund Type | Fund Class | Fund | Sub-Fund | Description
100000 | 000000 | 000000 | 000000 | 000000 | City |  | Count of Description | Column Labels
100000 | 130000 | 000000 | 000000 | 000000 | Fiduciary Funds |  | Row Labels | CDBG Fund | City | Citywide Donations | Community Development Block Grant | Enterprise Funds | Expendable Trust | Fiduciary Funds | Housing Revolving Loan Fund | Internal Service Funds | Library | Non-Expendable Trust | OPEB Trust - Memo Only | Proprietary Funds | Utility [NAME] | Utility Deposits | Water Capital Subfund | Water Infrastructure Subfund | Water Operating Subfund | Grand Total
100000 | 130000 | 490000 | 000000 | 000000 | Non-Expendable Trust |  | 100000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 21
100000 | 130000 | 490000 | 970000 | 000000 | OPEB Trust - Memo Only |  | 000000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 130000 | 490000 | 970000 | 970100 | OPEB Trust - Memo Only |  | 000000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 130000 | 560000 | 000000 | 000000 | Expendable Trust |  | 000000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 130000 | 560000 | 725000 | 000000 | Citywide Donations |  | 000000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 130000 | 560000 | 725000 | 725100 | Library |  | 120000 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 |  | 2 | 1 | 1 | 2 | 12
100000 | 130000 | 560000 | 725000 | 725109 | Utility [NAME] |  | 350000 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 | 1 | 1 | 2 | 7
100000 | 120000 | 000000 | 000000 | 000000 | Proprietary Funds |  | 455000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
100000 | 120000 | 350000 | 000000 | 000000 | Enterprise Funds |  | 455400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
100000 | 120000 | 350000 | 455000 | 000000 | Utility Deposits |  | 000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
100000 | 120000 | 350000 | 455000 | 455400 | Utility Deposits |  | 460000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 4
100000 | 120000 | 350000 | 460000 | 000000 | Water Operating Subfund |  | 460100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
100000 | 120000 | 350000 | 460000 | 460100 | Water Operating Subfund |  | 460200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
100000 | 120000 | 350000 | 460000 | 460200 | Water Capital Subfund |  | 460300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
100000 | 120000 | 350000 | 460000 | 460300 | Water Infrastructure Subfund |  | 000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
100000 | 120000 | 420000 | 000000 | 000000 | Internal Service Funds |  | 000000 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 120000 | 420000 | 110000 | 000000 | Community Development Block Grant |  | 000000 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
100000 | 120000 | 420000 | 110000 | 110100 | CDBG Fund |  | 420000 | 1 |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 4
100000 | 120000 | 420000 | 110000 | 110200 | Housing Revolving Loan Fund |  | 110000 | 1 |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 110100 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 110200 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 130000 |  |  | 1 |  |  | 1 | 1 |  |  | 1 | 1 | 2 |  | 1 |  |  |  |  | 8
 |  |  |  |  |  |  | 490000 |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 970000 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 970100 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 560000 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 4
 |  |  |  |  |  |  | 725000 |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 3
 |  |  |  |  |  |  | 725100 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 725109 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 000000 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | Grand Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 21