If there isn't a way for this to be done through pivot tables, does anyone have any ideas on what the easiest way would be to go about this using excel? Thanks!