Trouble with worksheet layout.
 

I need to track seven categories of expenses for 14 subdivisions, with data
for Budget, Revised Budget, Incurred To Date, Estimate To Complete, Total
Anticipated. Hopefully this can be done all on one worksheet without having
to scroll to infinity and beyond. I know this would be perfect for a pivot
table. I'm struggling with how to layout the data.
A B C D
E F
Budget, Rev Budget, IncrdToDate,
EstToCmplt, Total Anticptd
Subdivision 1
Permits
Blueprints
Legal fees
Consulting Fees
HOA Related
Property taxes
Misc
Subdivision 2
Subdivision 3, etc.

--
TIA, Nan