I have a user entering Belt inventory for all the schools in our County
There are over 300 Belt products for almost 200 schools
I am trying to have the pivot table list by each school every belt it has but just setting up the pivot seems arduous
of course I can filter on each school but that is time consuming too- basically belt data not blank
Any tips?
Sample data included
Thank you