Spreadsheet: 711360d1609641264-tabulate-and-graph-data-power-query-split-column-by-delimiter-marktilbrook-
Sheet: PQ Table

UID | SID | Program Name | Client | Client2 | [NAME] | Date | Behavioural Ranking
17 | 514 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Bed Wetting
17 | 514 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Escalation |  | Count of Behavioural Ranking | Behavioural Ranking
17 | 514 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Other (please specify): |  | Date | Attempting to Hurt Staff/Hurting Staff | Bed Wetting | Escalation | Ignoring Staff | No Behaviours | Other (please specify): | Pacing | Screaming /Yelling | Vocal | Grand Total
17 | 498 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | No Behaviours |  | 2020-09-10 00:00:00 |  | 1 | 3 |  | 1 | 1 | 1 |  |  | 7
17 | 499 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Escalation |  | 2020-09-11 00:00:00 |  | 2 |  |  |  | 1 |  |  |  | 3
17 | 488 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Escalation |  | 2020-09-12 00:00:00 |  | 1 | 2 |  |  |  | 1 | 1 |  | 5
17 | 488 | House Name | Client Name | Client Name | active | 2020-09-10 00:00:00 | Pacing |  | 2020-09-13 00:00:00 | 3 |  | 3 |  |  |  |  | 2 | 1 | 9
17 | 528 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Bed Wetting |  | 2020-09-14 00:00:00 | 3 |  |  |  |  |  | 1 |  |  | 4
17 | 526 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Bed Wetting |  | 2020-09-15 00:00:00 | 3 |  | 1 |  |  |  | 1 |  |  | 5
17 | 519 | House Name | Client Name | Client Name | active | 2020-09-11 00:00:00 | Other (please specify): |  | 2020-09-16 00:00:00 | 1 |  | 1 |  |  |  |  |  |  | 2
17 | 538 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Bed Wetting |  | 2020-09-17 00:00:00 |  |  |  |  | 1 |  |  |  |  | 1
17 | 538 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Escalation |  | 2020-09-18 00:00:00 |  |  |  |  | 1 |  | 1 |  | 1 | 3
17 | 538 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Pacing |  | 2020-09-19 00:00:00 |  |  |  | 1 |  |  | 2 |  |  | 3
17 | 538 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Screaming /Yelling |  | Grand Total | 10 | 4 | 10 | 1 | 3 | 2 | 7 | 3 | 2 | 42
17 | 530 | House Name | Client Name | Client Name | active | 2020-09-12 00:00:00 | Escalation
17 | 552 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Vocal
17 | 550 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 550 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Escalation
17 | 548 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 548 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Escalation
17 | 548 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Screaming /Yelling
17 | 547 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 545 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Escalation
17 | 545 | House Name | Client Name | Client Name | active | 2020-09-13 00:00:00 | Screaming /Yelling
17 | 567 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 566 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 565 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 555 | House Name | Client Name | Client Name | active | 2020-09-14 00:00:00 | Pacing
17 | 589 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 588 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 582 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Escalation
17 | 582 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Pacing
17 | 577 | House Name | Client Name | Client Name | active | 2020-09-15 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 598 | House Name | Client Name | Client Name | active | 2020-09-16 00:00:00 | Escalation
17 | 590 | House Name | Client Name | Client Name | active | 2020-09-16 00:00:00 | Attempting to Hurt Staff/Hurting Staff
17 | 638 | House Name | Client Name | Client Name | active | 2020-09-17 00:00:00 | No Behaviours
17 | 672 | House Name | Client Name | Client Name | active | 2020-09-18 00:00:00 | No Behaviours
17 | 649 | House Name | Client Name | Client Name | active | 2020-09-18 00:00:00 | Pacing
17 | 649 | House Name | Client Name | Client Name | active | 2020-09-18 00:00:00 | Vocal
17 | 720 | House Name | Client Name | Client Name | active | 2020-09-19 00:00:00 | Pacing
17 | 704 | House Name | Client Name | Client Name | active | 2020-09-19 00:00:00 | Ignoring Staff
17 | 704 | House Name | Client Name | Client Name | active | 2020-09-19 00:00:00 | Pacing