Spreadsheet: 711360d1609641264-tabulate-and-graph-data-power-query-split-column-by-delimiter-marktilbrook-
Sheet: PAST DATA HERE

UID | SID | Program Name | Client | Client2 | [NAME] | Date | Behavioural Ranking | Other (if applicable) | Start Time | End TIme
17 | 514 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Bed Wetting#Escalation#Other (please specify): | Other text | 19:00:00 | 22:30:00
17 | 498 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | No Behaviours | Other text | 08:30:00 | 17:30:00
17 | 499 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Escalation | Other text | 08:00:00 | 08:30:00
17 | 488 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Escalation#Pacing | Other text | 07:35:00 | 07:45:00
17 | 528 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Bed Wetting | Other text | 23:00:00 | 06:00:00
17 | 526 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Bed Wetting | Other text | 17:45:00 | 17:45:00
17 | 519 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Other (please specify): | Other text | 09:15:00 | 17:30:00
17 | 538 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Bed Wetting#Escalation#Pacing#Screaming /Yelling | Other text | 13:10:00 | 13:20:00
17 | 530 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Escalation | Other text | 17:30:00 | 10:10:00
17 | 552 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Vocal | Other text | 17:30:00 | 18:00:00
17 | 550 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff#Escalation | Other text | 16:30:00 | 16:35:00
17 | 548 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff#Escalation#Screaming /Yelling | Other text | 12:15:00 | 12:20:00
17 | 547 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 11:45:00 | 11:55:00
17 | 545 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Escalation#Screaming /Yelling | Other text | 10:00:00 | 10:05:00
17 | 567 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 16:37:00 | 16:40:00
17 | 566 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 10:00:00 | 11:30:00
17 | 565 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 10:00:00 | 11:30:00
17 | 555 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Pacing | Other text | 07:59:00 | 08:29:00
17 | 589 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 16:40:00 | 18:31:00
17 | 588 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 16:40:00 | 18:31:00
17 | 582 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Escalation#Pacing | Other text | 11:58:00 | 12:15:00
17 | 577 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 08:35:00 | 08:36:00
17 | 598 | House Name | Client Name | Client Name | active | 2020-09-16 00:00:00 | Escalation | Other text | 08:00:00 | 08:30:00
17 | 590 | House Name | Client Name | Client Name | active | 2020-09-16 00:00:00 | Attempting to Hurt Staff/Hurting Staff | Other text | 06:30:00 | 07:30:00
17 | 638 | House Name | Client Name | Client Name | active | 2020-09-17 00:00:00 | No Behaviours | Other text | 00:00:00 | 00:00:00
17 | 672 | House Name | Client Name | Client Name | active | 2020-09-18 00:00:00 | No Behaviours | Other text | 08:00:00 | 17:30:00
17 | 649 | House Name | Client Name | Client Name | active | 2020-09-18 00:00:00 | Pacing#Vocal | Other text | 07:15:00
17 | 720 | House Name | Client Name | Client Name | active | 2020-09-19 00:00:00 | Pacing | Other text | 12:16:00 | 12:30:00
17 | 704 | House Name | Client Name | Client Name | active | 2020-09-19 00:00:00 | Ignoring Staff#Pacing | Other text | 21:30:00 | 00:00:00