Spreadsheet: 327782d1403687767-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans3
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 | Introduced single quote at the beginning
5 | 111 | K | 1 | 0 | 0 |  |  |  | '212121 | $A$6 | 2 | Because 0000 and 000000 were being treated same.
6 | 111 | K | 1 | 0 | 0 | b | $A$2 | '101010 | '130102 | $A$7 | 1 | Now they are treated as separate.
7 |  |  |  |  |  |  |  |  | '00100000 | $A$8 | 2 | "Pattern of Values" give list of single values from UNIQUE Column.
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