Creating a report which aggregates count for multiple fields based on substring

Creating a report which aggregates count for multiple fields based on substring

Hope I'm describing this correctly, fairly new to this.  I am in charge of weekly schedules for my group of 14.  I would like to be able to generate reports which count how many times a specific group member is at a specific location, for a defined period of time. 

Currently, each record is based on a day, the fields for that record are the locations, and I select the group member who is assigned to that location through a drop-down box.

I can create a report which aggregates one location by placing the location field in the rows box, and using the count function in the data field. 

I would like to be able to generate a report that lists all the location fields at once, displaying all the locations in the rows, all the group members in the columns, and a count of how many times a member was at a location. 

Is this possible?  Thanks in advance.

Kris