Spreadsheet: 865724d1712741444-alphanumeric-sorting-4-elements-of-77-000-lines-sql-option-too-dummy-workbook-3
Sheet: Sheet1

 |  | Raw Data |  |  |  |  |  |  |  |  |  |  |  |  | Example of organised data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p.s not sure how I missed a couple off the end!
 |  | Column1 | Column2 | Column3 | SUBSTRING(FROM 38 FOR 2) | Number | Other information | Dates | Numbers | Column7 | Column8 | Column9 | Column10 |  | Number
 |  |  |  |  |  | 16:01..[NAME] |  |  |  |  |  |  |  |  | 8:2.a.90.1
 |  |  |  |  |  | 18:27.a.90.1 |  |  |  |  |  |  |  |  | 8:6.a.95.1
 |  |  |  |  |  | 18:01.a.90.1 |  |  |  |  |  |  |  |  | 16:01..[NAME]
 |  |  |  |  |  | 18:3.a.90.11a |  |  |  |  |  |  |  |  | 18:01.a.90.1
 |  |  |  |  |  | 18:3.a.90.12a, 12b |  |  |  |  |  |  |  |  | 18:27.a.90.1
 |  |  |  |  |  | 18:3.a.90.1a, 1b |  |  |  |  |  |  |  |  | 18:3.a.90.11a
 |  |  |  |  |  | 18:3.a.90.22 |  |  |  |  |  |  |  |  | 18:3.a.90.12a, 12b
 |  |  |  |  |  | 18:3.a.90.23 |  |  |  |  |  |  |  |  | 18:3.a.90.1a, 1b
 |  |  |  |  |  | 18:3.a.90.24-25 |  |  |  |  |  |  |  |  | 18:3.a.90.22
 |  |  |  |  |  | 18:3.a.90.26 |  |  |  |  |  |  |  |  | 18:3.a.90.23
 |  |  |  |  |  | 18:3.a.90.27 |  |  |  |  |  |  |  |  | 18:3.a.90.24-25
 |  |  |  |  |  | 62:46.a.200.1 |  |  |  |  |  |  |  |  | 18:3.a.90.26
 |  |  |  |  |  | 64:4.a.95.1 |  |  |  |  |  |  |  |  | 18:3.a.90.27
 |  |  |  |  |  | 64:4.a.95.10 |  |  |  |  |  |  |  |  | 64:4.a.95.1
 |  |  |  |  |  | 67:5.a.95.1 |  |  |  |  |  |  |  |  | 64:4.a.95.10
 |  |  |  |  |  | 67:7.a.90.1 |  |  |  |  |  |  |  |  | 67:5.a.95.1
 |  |  |  |  |  | 67:7.a.90.2 |  |  |  |  |  |  |  |  | 67:7.a.90.1
 |  |  |  |  |  | 67:7.a.90.3 |  |  |  |  |  |  |  |  | 67:7.a.90.2
 |  |  |  |  |  | 67:7.a.90.4 |  |  |  |  |  |  |  |  | 67:7.a.90.3
 |  |  |  |  |  | 67:7.a.90.5 |  |  |  |  |  |  |  |  | 67:7.a.90.4
 |  |  |  |  |  | 8:2.a.90.1 |  |  |  |  |  |  |  |  | 67:7.a.90.5
 |  |  |  |  |  | 8:6.a.95.1 |  |  |  |  |  |  |  |  | 96:5.a.90.1
 |  |  |  |  |  | 96:5.a.90.1 |  |  |  |  |  |  |  |  | 96:5.a.95.1
 |  |  |  |  |  | 96:5.a.95.1 |  |  |  |  |  |  |  |  | 97:5.a.95.2
 |  |  |  |  |  | 97:5.a.95.2 |  |  |  |  |  |  |  |  | 97:5.a.95.3
 |  |  |  |  |  | 97:5.a.95.3 |  |  |  |  |  |  |  |  | 1:3.b.200.13
 |  |  |  |  |  | 16:5.b.200.1 |  |  |  |  |  |  |  |  | 1:3.b.200.14
 |  |  |  |  |  | 16:5.b.201.1 |  |  |  |  |  |  |  |  | 1:3.b.200.15
 |  |  |  |  |  | 18:2.b.90.1-3 |  |  |  |  |  |  |  |  | 1:3.b.200.16
 |  |  |  |  |  | 18:27.b.201.1 |  |  |  |  |  |  |  |  | 1:3.b.200.17
 |  |  |  |  |  | 18:27.b.95.1 |  |  |  |  |  |  |  |  | 16:5.b.200.1
 |  |  |  |  |  | 1:3.b.200.12 |  |  |  |  |  |  |  |  | 16:5.b.201.1
 |  |  |  |  |  | 1:3.b.200.13 |  |  |  |  |  |  |  |  | 18:2.b.90.1-3
 |  |  |  |  |  | 1:3.b.200.14 |  |  |  |  |  |  |  |  | 18:27.b.201.1
 |  |  |  |  |  | 1:3.b.200.15 |  |  |  |  |  |  |  |  | 18:27.b.95.1
 |  |  |  |  |  | 1:3.b.200.16 |  |  |  |  |  |  |  |  | 21:8.b.95.2
 |  |  |  |  |  | 1:3.b.200.17 |  |  |  |  |  |  |  |  | 21:8.b.95.17-18
 |  |  |  |  |  | 21:8.b.95.17-18 |  |  |  |  |  |  |  |  | 21:8.b.95.19
 |  |  |  |  |  | 21:8.b.95.19 |  |  |  |  |  |  |  |  | 21:8.b.95.20
 |  |  |  |  |  | 21:8.b.95.2 |  |  |  |  |  |  |  |  | 21:8.b.95.20a
 |  |  |  |  |  | 21:8.b.95.20 |  |  |  |  |  |  |  |  | 97:3.b.95.4
 |  |  |  |  |  | 21:8.b.95.20a |  |  |  |  |  |  |  |  | 97:3.b.95.5
 |  |  |  |  |  | 158:25.b.90.1 |  |  |  |  |  |  |  |  | 97:5.b.200.1
 |  |  |  |  |  | 158:25.b.95.1 |  |  |  |  |  |  |  |  | 158:25.b.90.1
 |  |  |  |  |  | 158:3.b.95.1 |  |  |  |  |  |  |  |  | 158:25.b.95.1
 |  |  |  |  |  | 158:3.b.95.299 |  |  |  |  |  |  |  |  | 158:3.b.95.1
 |  |  |  |  |  | 97:3.b.95.4 |  |  |  |  |  |  |  |  | 158:3.b.95.299
 |  |  |  |  |  | 97:3.b.95.5 |  |  |  |  |  |  |  |  | 2:01.c.9.4
 |  |  |  |  |  | 97:5.b.200.1 |  |  |  |  |  |  |  |  | 2:01.c.9.5-6
 |  |  |  |  |  | 2:01.c.9.35 |  |  |  |  |  |  |  |  | 2:01.c.9.7
 |  |  |  |  |  | 2:01.c.9.4 |  |  |  |  |  |  |  |  | 2:01.c.9.8
 |  |  |  |  |  | 2:01.c.9.5-6 |  |  |  |  |  |  |  |  | 2:01.c.9.9
 |  |  |  |  |  | 2:01.c.9.7 |  |  |  |  |  |  |  |  | 2:01.c.9.35
 |  |  |  |  |  | 2:01.c.9.8 |  |  |  |  |  |  |  |  | 2:1.c.200.10
 |  |  |  |  |  | 2:01.c.9.9 |  |  |  |  |  |  |  |  | 2:1.c.200.11
 |  |  |  |  |  | 2:1.c.200.10 |  |  |  |  |  |  |  |  | 2:1.c.200.12
 |  |  |  |  |  | 2:1.c.200.11 |  |  |  |  |  |  |  |  | 2:1.c.200.13
 |  |  |  |  |  | 2:1.c.200.12 |  |  |  |  |  |  |  |  | 2:1.c.200.14
 |  |  |  |  |  | 2:1.c.200.13 |  |  |  |  |  |  |  |  | 2:1.c.200.15
 |  |  |  |  |  | 2:1.c.200.14 |  |  |  |  |  |  |  |  | 2:1.c.200.16
 |  |  |  |  |  | 2:1.c.200.15 |  |  |  |  |  |  |  |  | 8:2.c.95.97
 |  |  |  |  |  | 2:1.c.200.16 |  |  |  |  |  |  |  |  | 8:3.c.200.1
 |  |  |  |  |  | 35:01.c.6 |  |  |  |  |  |  |  |  | 8:3.c.200.2-4
 |  |  |  |  |  | 35:01.c.6.100 |  |  |  |  |  |  |  |  | 8:3.c.200.5
 |  |  |  |  |  | 35:01.c.6.101 |  |  |  |  |  |  |  |  | 35:01.c.6
 |  |  |  |  |  | 35:01.c.6.102 |  |  |  |  |  |  |  |  | 35:01.c.6.100
 |  |  |  |  |  | 96:1.c.90.8 |  |  |  |  |  |  |  |  | 35:01.c.6.101
 |  |  |  |  |  | 96:1.c.90.9 |  |  |  |  |  |  |  |  | 35:01.c.6.102
 |  |  |  |  |  | 96:1.c.95.1 |  |  |  |  |  |  |  |  | 80.c.95.320
 |  |  |  |  |  | 96:1.c.95.10 |  |  |  |  |  |  |  |  | 80.c.95.321-322
 |  |  |  |  |  | 96:1.c.95.100 |  |  |  |  |  |  |  |  | 80.c.95.323
 |  |  |  |  |  | 96:1.c.95.101 |  |  |  |  |  |  |  |  | 96:1.c.90.8
 |  |  |  |  |  | 8:2.c.95.97 |  |  |  |  |  |  |  |  | 96:1.c.90.9
 |  |  |  |  |  | 8:3.c.200.1 |  |  |  |  |  |  |  |  | 96:1.c.95.1
 |  |  |  |  |  | 8:3.c.200.2-4 |  |  |  |  |  |  |  |  | 96:1.c.95.10
 |  |  |  |  |  | 8:3.c.200.5 |  |  |  |  |  |  |  |  | 96:1.c.95.100
 |  |  |  |  |  | 53:7.d.95.40 |  |  |  |  |  |  |  |  | 96:1.c.95.101
 |  |  |  |  |  | 53:7.d.95.41 |  |  |  |  |  |  |  |  | 53:7.d.95.40
 |  |  |  |  |  | 53:7.d.95.42 |  |  |  |  |  |  |  |  | 53:7.d.95.41
 |  |  |  |  |  | 53:7.d.95.43 |  |  |  |  |  |  |  |  | 53:7.d.95.42
 |  |  |  |  |  | 80.c.95.320 |  |  |  |  |  |  |  |  | 53:7.d.95.43
 |  |  |  |  |  | 80.c.95.321-322
 |  |  |  |  |  | 80.c.95.323