Hello all, I want to find to find a way to summarise and easily view the activities that are taking place each week in several areas on a construction project. Each activity has a type (13 possibilities), an area (52 possibilities) and has start and finish dates. The raw data is arranged so that all this information is contained on one row for each activity (around 6000 rows in total). Like this (UK style dates) -
'Activity name' Activity type 1 Area 1 23/04/2019 05/05/2019 'Activity name' Activity type 2 Area 1 08/05/2019 09/05/2019 'Activity name' Activity type 1 Area 3 24/04/2019 28/04/2019 'Activity name' Activity type 3 Area 2 29/04/2019 04/05/2019 'Activity name' Activity type 5 Area 2 30/04/2019 03/05/2019 'Activity name' Activity type 2 Area 3 30/04/2019 03/05/2019
I'd like to be able to see what activity types are taking place in each area on a weekly basis similar to the layout here -
Week start Week finish Area 1 Area 2 Area 3 22/04/19 28/04/19 Activity type 1 Activity type 1 29/04/19 05/05/19 Activity type 1 Activity type 3, Activity type 5 Activity type 2 06/05/19 12/05/19 Activity type 2
I could create a column for each activity type for each area and lookup if that type is taking place in that area for a given week and the summarise that into singles cells but this would require 676 columns (13 types x 52 areas) so I'd prefer a more efficient way if anyone can think of one?
Thanks!
Bookmarks