Spreadsheet: 701166d1603580706-display-data-from-a-data-table-in-a-planner-view-room-allocation
Sheet: Data

Name | Date | Start Time | End Time | Activity |  | Name | Start | End
Person 1 | 2020-10-19 00:00:00 | 08:00:00 | 14:00:00 | Red Room |  | Person 1
Person 1 | 2020-10-19 00:00:00 | 16:00:00 | 18:00:00 | Purple Room |  | Person 2
Person 2 | 2020-10-19 00:00:00 | 08:00:00 | 10:00:00 | Yellow Room |  | Person 3
Person 2 | 2020-10-19 00:00:00 | 10:00:00 | 12:00:00 | Pink Room |  | Person 4
Person 2 | 2020-10-19 00:00:00 | 12:00:00 | 16:00:00 | Blue Room |  | Person 5
Person 3 | 2020-10-19 00:00:00 | 08:00:00 | 10:00:00 | Green Room |  | Person 6
Person 3 | 2020-10-19 00:00:00 | 10:00:00 | 14:00:00 | Blue Room |  | Person 7
Person 3 | 2020-10-19 00:00:00 | 14:00:00 | 16:00:00 | Pink Room |  | Person 8
Person 3 | 2020-10-19 00:00:00 | 16:00:00 | 18:00:00 | Blue Room
Person 5 | 2020-10-19 00:00:00 | 08:00:00 | 12:00:00 | Blue Room
Person 5 | 2020-10-19 00:00:00 | 14:00:00 | 18:00:00 | Yellow Room
Person 6 | 2020-10-19 00:00:00 | 09:00:00 | 15:00:00 | Yellow Room
Person 7 | 2020-10-19 00:00:00 | 12:00:00 | 18:00:00 | Green Room |  | Ideally need to be able to display 2 months worth of data on the visual page, based on the starting date
Person 8 | 2020-10-19 00:00:00 | 08:00:00 | 14:00:00 | Purple Room
Person 4 | 2020-10-19 00:00:00 | 08:00:00 | 18:00:00 | Off
Person 1 | 2020-10-20 00:00:00 | 08:00:00 | 14:00:00 | Off
Person 1 | 2020-10-20 00:00:00 | 16:00:00 | 18:00:00 | Off
Person 2 | 2020-10-20 00:00:00 | 08:00:00 | 10:00:00 | Off
Person 2 | 2020-10-20 00:00:00 | 10:00:00 | 12:00:00 | Off
Person 2 | 2020-10-20 00:00:00 | 12:00:00 | 16:00:00 | Blue Room
Person 3 | 2020-10-20 00:00:00 | 08:00:00 | 10:00:00 | Blue Room
Person 3 | 2020-10-20 00:00:00 | 10:00:00 | 14:00:00 | Yellow Room
Person 3 | 2020-10-20 00:00:00 | 14:00:00 | 16:00:00 | Blue Room
Person 3 | 2020-10-20 00:00:00 | 16:00:00 | 18:00:00 | Blue Room
Person 5 | 2020-10-20 00:00:00 | 08:00:00 | 12:00:00 | Yellow Room
Person 5 | 2020-10-20 00:00:00 | 14:00:00 | 18:00:00 | Yellow Room
Person 6 | 2020-10-20 00:00:00 | 09:00:00 | 15:00:00 | Yellow Room
Person 7 | 2020-10-20 00:00:00 | 12:00:00 | 18:00:00 | Green Room
Person 8 | 2020-10-20 00:00:00 | 08:00:00 | 14:00:00 | Purple Room
Person 4 | 2020-10-20 00:00:00 | 08:00:00 | 18:00:00 | Red Room
Person 1 | 2020-10-21 00:00:00 | 08:00:00 | 14:00:00 | Red Room
Person 1 | 2020-10-21 00:00:00 | 16:00:00 | 18:00:00 | Red Room
Person 2 | 2020-10-21 00:00:00 | 08:00:00 | 10:00:00 | Off
Person 2 | 2020-10-21 00:00:00 | 10:00:00 | 12:00:00 | Off
Person 2 | 2020-10-21 00:00:00 | 12:00:00 | 16:00:00 | Blue Room
Person 3 | 2020-10-21 00:00:00 | 08:00:00 | 10:00:00 | Blue Room
Person 3 | 2020-10-21 00:00:00 | 10:00:00 | 14:00:00 | Yellow Room
Person 3 | 2020-10-21 00:00:00 | 14:00:00 | 16:00:00 | Blue Room
Person 3 | 2020-10-21 00:00:00 | 16:00:00 | 18:00:00 | Blue Room
Person 5 | 2020-10-21 00:00:00 | 08:00:00 | 12:00:00 | Off
Person 5 | 2020-10-21 00:00:00 | 14:00:00 | 18:00:00 | Off
Person 6 | 2020-10-21 00:00:00 | 09:00:00 | 15:00:00 | Yellow Room
Person 7 | 2020-10-21 00:00:00 | 12:00:00 | 18:00:00 | Green Room
Person 8 | 2020-10-21 00:00:00 | 08:00:00 | 14:00:00 | Purple Room
Person 4 | 2020-10-21 00:00:00 | 08:00:00 | 18:00:00 | Yellow Room