Why not just use pivot table processing? You can even consolidate
multiple ranges (your different worksheets) to combine them as them as
a single database virtually to use as input to the pivot table
process. Then city_type and fare_type just become two fields within
the pivot table process.