Spreadsheet: 327716d1403656633-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans2dan
Sheet: Sheet11

SERIES | ACCIDENT_ID | SEVERITY | KILLED | INJURED | DUPLICATE | PATTERN | PATTERN2 | UNIQUE | Pattern of Values | [NAME] ASSIGNED | COUNT
0 | 111 | PDO | 0 | 0 | DEL |  |  |  | 000000 | $A$1
1 | 111 | PDO | 0 | 0 | DEL |  |  |  | 101010 | $A$2
2 | 111 | PDO | 0 | 0 | DEL |  | $A$1 | 000000 | 111001 | $A$3
3 |  |  |  |  |  |  |  |  | 010101 | $A$4
4 |  | K | 1 | 0 | 0 |  |  |  | 100101 | $A$5
5 | 111 | K | 1 | 0 | 0 |  |  |  | 212121 | $A$6
6 | 111 | K | 1 | 0 | 0 |  | $A$2 | 101010 | 130102 | $A$7
7 |  |  |  |  |  |  |  |  | 00100000 | $A$8
8 | 0 | K | 1 | 1 | 0 |  |  |  | 1414 | $A$9
9 | 111 | K | 1 | 0 | 0 |  |  |  | 01100100 | $A$10
10 | 111 | I | 0 | 1 | DEL |  | $A$3 | 111001 |  | $A$11
11 |  |  |  |  |  |  |  |  |  | $A$12
12 | 0 | PDO | 0 | 0 | DEL |  |  |  |  | $A$13
13 | 111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$14
14 | 111 | PDO | 0 | 0 | DEL |  | $A$1 | 000000 |  | $A$15
15 |  |  |  |  |  |  |  |  |  | $A$16
16 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$17
17 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$18
18 | 111 | K | 1 | 0 | 0 |  | $A$2 | 101010 |  | $A$19
19 |  |  |  |  |  |  |  |  |  | $A$20
20 | 0 | I | 0 | 1 | 0 |  |  |  |  | $A$21
21 | 111 | I | 0 | 1 | 0 |  |  |  |  | $A$22
22 | 111 | I | 0 | 1 | 0 |  | $A$4 | 010101 |  | $A$23
23 |  |  |  |  |  |  |  |  |  | $A$24
24 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$25
25 | 111 | I | 0 | 1 | DEL |  |  |  |  | $A$26
26 | 111 | I | 0 | 1 | DEL |  | $A$5 | 100101 |  | $A$27
27 |  |  |  |  |  |  |  |  |  | $A$28
28 | 0 | K | 2 | 1 | 0 |  |  |  |  | $A$29
29 | 111 | K | 2 | 1 | 0 |  |  |  |  | $A$30
30 | 111 | K | 2 | 1 | 0 |  | $A$6 | 212121 |  | $A$31
31 |  |  |  |  |  |  |  |  |  | $A$32
32 | 0 | K | 1 | 3 | 0 |  |  |  |  | $A$33
33 | 111 | I | 0 | 1 | DEL |  |  |  |  | $A$34
34 | 111 | I | 0 | 2 | DEL |  | $A$7 | 130102 |  | $A$35
35 |  |  |  |  |  |  |  |  |  | $A$36
36 | 0 | K | 1 | 1 | 0 |  |  |  |  | $A$37
37 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$38
38 | 111 | I | 0 | 1 | DEL |  | $A$3 | 111001 |  | $A$39
39 |  |  |  |  |  |  |  |  |  | $A$40
40 | 1111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$41
41 | 1111 | K | 1 | 0 | 0 |  |  |  |  | $A$42
42 | 1111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$43
43 | 1111 | PDO | 0 | 0 | DEL |  | $A$8 | 00100000 |  | $A$44
44 |  |  |  |  |  |  |  |  |  | $A$45
45 | 1112 | K | 1 | 4 | 0 |  |  |  |  | $A$46
46 | 1112 | K | 1 | 4 | 0 |  | $A$9 | 1414 |  | $A$47
47 |  |  |  |  |  |  |  |  |  | $A$48
48 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$49
49 | 2222 | K | 1 | 0 | 0 |  |  |  |  | $A$50
50 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$51
51 | 2222 | PDO | 0 | 0 | DEL |  | $A$10 | 01100100 |  | $A$52
52 |  |  |  |  |  |  |  |  |  | $A$53
53 |  |  | 0 | 0 |  |  |  |  |  | $A$54
54 |  |  | 3 | 1 |  |  |  |  |  | $A$55
55 |  |  | 2 | 1 |  |  | #N/A | 003121 |  | $A$56
56 |  |  |  |  |  |  |  |  |  | $A$57
57 |  |  | 0 | 1 |  |  |  |  |  | $A$58
58 |  |  | 0 | 1 |  |  |  |  |  | $A$59
59 |  |  | 0 | 2 |  |  | #N/A | 010102 |  | $A$60
60 |  |  |  |  |  |  |  |  |  | $A$61
61 |  |  | 0 | 1 |  |  |  |  |  | $A$62
62 |  |  |  |  |  |  |  |  |  | $A$63
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77