Grouping By Type and Location

[bruntonomo]

The purpose of this task is to set something up so that it can answer the question, "Where are certain types of problems happening and how often?"

Below is a sheet that I input all the data from reports I receive. This sheet is what my end product will be referencing.

I am trying to create a table/spreadsheet that will check the reports data input sheet above to see when an activity type is logged and then puts it into the spreadsheet in a way that groups everything by type of issue. Then it keeps track of the locations in which this particular activity type shows up and keeps a running tally of the number of times it shows up in that location.

I know how to use a COUNTIFS function to count how many times the activity type shows up in a location. The kicker is setting it up so that if a new activity type is logged, it creates a new listing in the table/spreadsheet. Likewise, if a new location is logged for an activity type, it automatically adds it under the activity type. Is this possible? Below is roughly how the end product should look.

 

[J.Ty.]

What is your Excel variant?

 

[Larry Haydn]

A pivot table will do that nicely.

 

[bruntonomo]

What is your Excel variant?

Excel variant? Do you mean version?

 

[bruntonomo]

A pivot table will do that nicely.

I will look into that. Part of the problem is knowing terminology for what you're trying to do. Thank you for the suggestion!