I was given a spreadsheet that lists data in columns (Manager Name, Region, Department, Car 1, Car 2, Car 3, etc.). I need to be able to figure out the total number of each type of car based on the region, manager, etc. (there are about 50 different car models). I'm trying to figure out how to normalize the data without creating 50 new columns for each different model of car. I've tried creating pivots, but I have to make three separate tables and then add them. I am certain that I am overlooking something embarrassingly obvious, but I could really use some help. Thanks very much in advance!