Help Summarizing Data Based on Multiple Factors

I am trying to create a consolidated summary of some data I'm working on for a vendor.  I have a list of individuals that includes columns for their ID number, company, state, class, and what their t...