Spreadsheet: 859569d1707914135-merging-tables-in-power-query-test-spreadsheet-1-aligw
Sheet: AllData

Name | Employee ID | Number of Cases | High Compliance | Compliant | Partial Compliance | Low Compliance | Non-Compliant
a | 1 | 2 | 0 | 0 | 0 | 1 | 1
a | 2 | 3 | 2 | 1 | 0 | 0 | 0
a | 3 | 1 | 1 | 0 | 0 | 0 | 0
a | 4 | 2 | 2 | 0 | 0 | 0 | 0
a | 5 | 3 | 1 | 1 | 1 | 0 | 0
a | 6 | 1 | 0 | 1 | 0 | 0 | 0
a | 7 | 1 | 1 | 0 | 0 | 0 | 0
a | 8 | 2 | 1 | 1 | 0 | 0 | 0
a | 9 | 1 | 0 | 1 | 0 | 0 | 0
a | 10 | 4 | 3 | 1 | 0 | 0 | 0
a | 11 | 3 | 2 | 1 | 0 | 0 | 0
a | 12 | 2 | 1 | 0 | 1 | 0 | 0
a | 13 | 2 | 1 | 0 | 0 | 0 | 1
a | 14 | 1 | 1 | 0 | 0 | 0 | 0
a | 15 | 1 | 1 | 0 | 0 | 0 | 0
a | 16 | 2 | 1 | 0 | 1 | 0 | 0
a | 17 | 5 | 0 | 5 | 0 | 0 | 0
a | 18 | 3 | 3 | 0 | 0 | 0 | 0
a | 19 | 8 | 3 | 4 | 1 | 0 | 0
a | 20 | 4 | 4 | 0 | 0 | 0 | 0
a | 21 | 5 | 3 | 1 | 0 | 0 | 1
a | 22 | 3 | 2 | 1 | 0 | 0 | 0
a | 23 | 2 | 0 | 0 | 2 | 0 | 0
a | 24 | 2 | 2 | 0 | 0 | 0 | 0
a | 25 | 4 | 3 | 1 | 0 | 0 | 0
a | 26 | 3 | 1 | 2 | 0 | 0 | 0
a | 27 | 2 | 2 | 0 | 0 | 0 | 0
a | 28 | 3 | 3 | 0 | 0 | 0 | 0
b | 29 | 2 | 2 | 0 | 0 | 0 | 0
b | 30 | 1 | 1 | 0 | 0 | 0 | 0
b | 31 | 1 | 1 | 0 | 0 | 0 | 0
b | 32 | 2 | 2 | 0 | 0 | 0 | 0
b | 33 | 4 | 3 | 1 | 0 | 0 | 0
b | 34 | 1 | 1 | 0 | 0 | 0 | 0
b | 35 | 2 | 1 | 1 | 0 | 0 | 0
b | 36 | 1 | 1 | 0 | 0 | 0 | 0
b | 37 | 6 | 1 | 4 | 0 | 0 | 1
b | 38 | 2 | 2 | 0 | 0 | 0 | 0
b | 39 | 4 | 2 | 1 | 1 | 0 | 0
b | 40 | 3 | 3 | 0 | 0 | 0 | 0
b | 41 | 2 | 1 | 0 | 0 | 0 | 1
b | 42 | 5 | 3 | 2 | 0 | 0 | 0
b | 43 | 1 | 1 | 0 | 0 | 0 | 0
b | 44 | 4 | 2 | 2 | 0 | 0 | 0
b | 45 | 2 | 1 | 1 | 0 | 0 | 0
b | 46 | 5 | 4 | 0 | 0 | 0 | 1
b | 47 | 1 | 1 | 0 | 0 | 0 | 0
b | 48 | 2 | 2 | 0 | 0 | 0 | 0
b | 49 | 3 | 2 | 1 | 0 | 0 | 0
b | 50 | 4 | 3 | 1 | 0 | 0 | 0
b | 51 | 2 | 2 | 0 | 0 | 0 | 0
b | 52 | 3 | 3 | 0 | 0 | 0 | 0
b | 53 | 3 | 3 | 0 | 0 | 0 | 0
b | 54 | 1 | 0 | 1 | 0 | 0 | 0
b | 55 | 1 | 0 | 0 | 0 | 1 | 0
b | 56 | 2 | 2 | 0 | 0 | 0 | 0
b | 57 | 1 | 0 | 0 | 1 | 0 | 0
b | 58 | 1 | 1 | 0 | 0 | 0 | 0
b | 59 | 2 | 2 | 0 | 0 | 0 | 0
b | 60 | 1 | 1 | 0 | 0 | 0 | 0
c | 61 | 2 | 2 | 0 | 0 | 0 | 0
c | 62 | 1 | 1 | 0 | 0 | 0 | 0
c | 63 | 1 | 1 | 0 | 0 | 0 | 0
c | 64 | 2 | 2 | 0 | 0 | 0 | 0
c | 65 | 4 | 3 | 1 | 0 | 0 | 0
c | 66 | 1 | 1 | 0 | 0 | 0 | 0
c | 67 | 2 | 1 | 1 | 0 | 0 | 0
c | 68 | 1 | 1 | 0 | 0 | 0 | 0
c | 69 | 6 | 1 | 4 | 0 | 0 | 1
c | 70 | 2 | 2 | 0 | 0 | 0 | 0
c | 71 | 4 | 2 | 1 | 1 | 0 | 0
c | 72 | 3 | 3 | 0 | 0 | 0 | 0
c | 73 | 2 | 1 | 0 | 0 | 0 | 1
c | 74 | 5 | 3 | 2 | 0 | 0 | 0
c | 75 | 1 | 1 | 0 | 0 | 0 | 0
c | 76 | 4 | 2 | 2 | 0 | 0 | 0
c | 77 | 2 | 1 | 1 | 0 | 0 | 0
c | 78 | 5 | 4 | 0 | 0 | 0 | 1
c | 79 | 1 | 1 | 0 | 0 | 0 | 0
c | 80 | 2 | 2 | 0 | 0 | 0 | 0
c | 81 | 3 | 2 | 1 | 0 | 0 | 0
c | 82 | 4 | 3 | 1 | 0 | 0 | 0
c | 83 | 2 | 2 | 0 | 0 | 0 | 0
c | 84 | 3 | 3 | 0 | 0 | 0 | 0
c | 85 | 3 | 3 | 0 | 0 | 0 | 0
c | 86 | 1 | 0 | 1 | 0 | 0 | 0
c | 87 | 1 | 0 | 0 | 0 | 1 | 0
c | 88 | 2 | 2 | 0 | 0 | 0 | 0
c | 89 | 1 | 0 | 0 | 1 | 0 | 0
c | 90 | 1 | 1 | 0 | 0 | 0 | 0
c | 91 | 2 | 2 | 0 | 0 | 0 | 0
c | 92 | 1 | 1 | 0 | 0 | 0 | 0
d | 93 | 2 | 2 | 0 | 0 | 0 | 0
d | 94 | 1 | 1 | 0 | 0 | 0 | 0
d | 95 | 1 | 1 | 0 | 0 | 0 | 0
d | 96 | 2 | 2 | 0 | 0 | 0 | 0
d | 97 | 4 | 3 | 1 | 0 | 0 | 0
d | 98 | 1 | 1 | 0 | 0 | 0 | 0
d | 99 | 2 | 1 | 1 | 0 | 0 | 0
d | 100 | 1 | 1 | 0 | 0 | 0 | 0
d | 101 | 6 | 1 | 4 | 0 | 0 | 1
d | 102 | 2 | 2 | 0 | 0 | 0 | 0
d | 103 | 4 | 2 | 1 | 1 | 0 | 0
d | 104 | 3 | 3 | 0 | 0 | 0 | 0
d | 105 | 2 | 1 | 0 | 0 | 0 | 1
d | 106 | 5 | 3 | 2 | 0 | 0 | 0
d | 107 | 1 | 1 | 0 | 0 | 0 | 0
d | 108 | 4 | 2 | 2 | 0 | 0 | 0
d | 109 | 2 | 1 | 1 | 0 | 0 | 0
d | 110 | 5 | 4 | 0 | 0 | 0 | 1
d | 111 | 1 | 1 | 0 | 0 | 0 | 0
d | 112 | 2 | 2 | 0 | 0 | 0 | 0
d | 113 | 3 | 2 | 1 | 0 | 0 | 0
d | 114 | 4 | 3 | 1 | 0 | 0 | 0
d | 115 | 2 | 2 | 0 | 0 | 0 | 0
d | 116 | 3 | 3 | 0 | 0 | 0 | 0
d | 117 | 3 | 3 | 0 | 0 | 0 | 0
d | 118 | 1 | 0 | 1 | 0 | 0 | 0
d | 119 | 1 | 0 | 0 | 0 | 1 | 0
d | 120 | 2 | 2 | 0 | 0 | 0 | 0
d | 121 | 1 | 0 | 0 | 1 | 0 | 0
d | 122 | 1 | 1 | 0 | 0 | 0 | 0
d | 123 | 2 | 2 | 0 | 0 | 0 | 0
d | 124 | 1 | 1 | 0 | 0 | 0 | 0