Spreadsheet: 326453d1403170626-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans
Sheet: Sheet8

SERIES | ACCIDENT_ID | SEVERITY | KILLED | INJURED | DUPLICATE | PATTERN | PATTERN2 | UNIQUE | Pattern of Values | [NAME] ASSIGNED | UDF USED | COUNT
0 | 111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$1 |  |  |  |  |  |  |  |  |  |  |  | a | a
1 | 111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$2 |  | 2 |  |  |  |  |  |  |  |  |  | b
2 | 111 | PDO | 0 | 0 | DEL | a | $A$3 | 000000 | 000000 | $A$3 | 000000 | 2 |  |  |  |  |  |  |  |  |  | c
3 |  |  |  |  |  |  |  |  | 101010 | $A$4 |  | 2 |  |  |  |  |  |  | A | 0
4 |  | K | 1 | 0 | 0 |  |  |  | 111001 | $A$5 |  | 1 |  |  |  |  |  | 0 | B | 0
5 | 111 | K | 1 | 0 | 0 |  |  |  | 010101 | $A$6 |  | 1 |  |  |  |  |  | 0 | C | 0
6 | 111 | K | 1 | 0 | 0 | b | $A$4 | 101010 | 100101 | $A$7 | 101010 | 1 |  |  |  |  |  | 0 | D | 0
7 |  |  |  |  |  |  |  |  | 212121 | $A$8 |  | 1 |  |  |  |  |  | 0 | E | 0
8 | 0 | K | 1 | 1 | 0 |  |  |  | 130102 | $A$9 |  |  |  |  |  |  |  | 0 | F | 0
9 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$10 |  |  |  |  |  |  |  | 0 | G | 0
10 | 111 | I | 0 | 1 | DEL | c | $A$5 | 111001 |  | $A$11 | 111001 |  |  |  |  |  |  | 0 | H | 0
11 |  |  |  |  |  |  |  |  |  | $A$12 |  | UDF is used. |  |  |  |  |  | 0 | I | 0
12 | 0 | PDO | 0 | 0 | DEL |  |  |  |  | $A$13 |  |  |  |  |  |  |  | 0 | J | 0
13 | 111 | PDO | 0 | 0 | DEL |  |  |  |  | $A$14 |  |  |  |  |  |  |  | 0 | K | 0
14 | 111 | PDO | 0 | 0 | DEL | a | $A$3 | 000000 |  | $A$15 | 000000 |  |  |  |  |  |  | 0 | L | 0
15 |  |  |  |  |  |  |  |  |  | $A$16 |  |  |  |  |  |  |  | 0 | M | 0
16 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$17 |  |  |  |  |  |  |  | 0 | N | 0
17 | 111 | K | 1 | 0 | 0 |  |  |  |  | $A$18 |  |  |  |  |  |  |  | 0 | O | 0
18 | 111 | K | 1 | 0 | 0 | b | $A$4 | 101010 |  | $A$19 | 101010 |  |  |  |  |  |  | 0 | P | 0
19 |  |  |  |  |  |  |  |  |  | $A$20 |  |  |  |  |  |  |  | 0 | Q | 0
20 | 0 | I | 0 | 1 | 0 |  |  |  |  | $A$21 |  |  |  |  |  |  |  | 0 | R | 0
21 | 111 | I | 0 | 1 | 0 |  |  |  |  | $A$22 |  |  |  |  |  |  |  | 0 | S | 0
22 | 111 | I | 0 | 1 | 0 | d | $A$6 | 010101 |  | $A$23 | 010101 |  |  |  |  |  |  | 0 | T | 0
23 |  |  |  |  |  |  |  |  |  | $A$24 |  |  |  |  |  |  |  | 0 | U | 0
24 | 0 | K | 1 | 0 | 0 |  |  |  |  | $A$25 |  |  |  |  |  |  |  | 0 | V | 0
25 | 111 | I | 0 | 1 | DEL |  |  |  |  | $A$26 |  |  |  |  |  |  |  | 0 | W | 0
26 | 111 | I | 0 | 1 | DEL | e | $A$7 | 100101 |  | $A$27 | 100101 |  |  |  |  |  |  | 0 | X | 0
27 |  |  |  |  |  |  |  |  |  | $A$28 |  |  |  |  |  |  |  | 0 | Y | 0
28 | 0 | K | 2 | 1 | 0 |  |  |  |  | $A$29 |  |  |  |  |  |  |  | 0 | Z | 0
29 | 111 | K | 2 | 1 | 0 |  |  |  |  | $A$30
30 | 111 | K | 2 | 1 | 0 | f | $A$8 | 212121 |  | $A$31 | 212121
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 | g | $A$9 | 130102 |  | $A$35 | 130102
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 | c | $A$5 | 111001 |  | $A$39 | 111001
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 | h |  |  |  | $A$43
42 | 1111 | PDO | 0 | 0 | DEL |  |  | 00100000 |  | $A$44 | 00100000
42 |  |  |  |  |  |  |  |  |  | $A$45
42 | 1112 | K | 1 | 4 | 0 | i |  |  |  | $A$46
42 | 1112 | K | 1 | 4 | 0 |  |  | 1414 |  | $A$47 | 1414
42 |  |  |  |  |  |  |  |  |  | $A$48
42 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$49
42 | 2222 | K | 1 | 0 | 0 |  |  |  |  | $A$50
42 | 2222 | I | 0 | 1 | DEL |  |  |  |  | $A$51
42 | 2222 | PDO | 0 | 0 | DEL |  |  | 01100100 |  | $A$52 | 01100100
42
42 |  |  | 0 | 0
 |  |  |  |  |  |  |  | 000014