Spreadsheet: 328007d1403763941-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans4
Sheet: Sheet8

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 | 3 | UDF is used.
1 | 111 | PDO | 0 | 0 | DEL |  |  |  | 101010 | $A$2 | 2
2 | 111 | PDO | 0 | 0 | DEL | a | $A$1 | 000000 | 111001 | $A$3 | 2
3 |  |  |  |  |  |  |  |  | 010101 | $A$4 | 2 | [NAME] in Column I is changed.
4 |  | K | 1 | 0 | 0 |  |  |  | 100101 | $A$5 | 1 | No necessity of single quote now.
5 | 111 | K | 1 | 0 | 0 |  |  |  | 212121 | $A$6 | 2
6 | 111 | K | 1 | 0 | 0 | b | $A$2 | 101010 | 130102 | $A$7 | 1
7 |  |  |  |  |  |  |  |  | 00100000 | $A$8 | 2
8 | 0 | K | 1 | 1 | 0 |  |  |  | 1414 | $A$9 | 1
9 | 111 | K | 1 | 0 | 0 |  |  |  | 01100100 | $A$10 | 2
10 | 111 | I | 0 | 1 | DEL | c | $A$3 | 111001 | 003121 | $A$11 | 1
11 |  |  |  |  |  |  |  |  | 0101 | $A$12 | 2
12 | 0 | PDO | 0 | 0 | DEL |  |  |  | 0011 | $A$13 | 1
13 | 111 | PDO | 0 | 0 | DEL |  |  |  | 0000 | $A$14 | 2
14 | 111 | PDO | 0 | 0 | DEL | a | $A$1 | 000000 | 1112 | $A$15 | 1
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 | b | $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 | d | $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 | e | $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 | f | $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 | g | $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 | c | $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 | h |  |  |  | $A$43
42 | 1111 | PDO | 0 | 0 | DEL |  | $A$8 | 00100000 |  | $A$44
42 |  |  |  |  |  |  |  |  |  | $A$45
42 | 1112 | K | 1 | 4 | 0 | i |  |  |  | $A$46
42 | 1112 | K | 1 | 4 | 0 |  | $A$9 | 1414 |  | $A$47
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 |  | $A$10 | 01100100 |  | $A$52
42
42 |  |  | 0 | 0
 |  |  | 3 | 1
 |  |  | 2 | 1 |  |  | $A$11 | 003121
 |  |  | 0 | 1
 |  |  | 0 | 1 |  |  | $A$12 | 0101
 |  |  | 0 | 0
 |  |  | 1 | 1 |  |  | $A$13 | 0011
 |  |  | 0 | 0
 |  |  | 1 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0 |  |  | $A$8 | 00100000
 |  |  | 0 | 1
 |  |  | 0 | 1 |  |  | $A$12 | 0101
 |  |  | 0 | 1
 |  |  | 0 | 1
 |  |  | 0 | 1 |  |  | $A$4 | 010101
 |  |  | 2 | 1
 |  |  | 2 | 1
 |  |  | 2 | 1 |  |  | $A$6 | 212121
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0 |  |  | $A$1 | 000000
 |  |  | 0 | 1
 |  |  | 1 | 0
 |  |  | 0 | 1
 |  |  | 0 | 0 |  |  | $A$10 | 01100100
 |  |  | 0 | 0
 |  |  | 0 | 0 |  |  | $A$14 | 0000
 |  |  | 1 | 1
 |  |  | 1 | 2 |  |  | $A$15 | 1112
 |  |  | 0 | 0
 |  |  | 0 | 0 |  |  | $A$14 | 0000
 |  |  | 0 | 0