MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.7.27


CREATE TABLE IF NOT EXISTS `parts_listing` (
  `ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `GroupNumber` varchar(20) DEFAULT NULL,
  `PartNo` varchar(30) DEFAULT NULL,
  `Models` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

INSERT INTO `parts_listing` (`ID`, `GroupNumber`, `PartNo`, `Models`) VALUES
    (1, '0.000', '391906', '2201-02-11-20-22-32-40; 2301'),
    (2, '0.000', '391907', '2206-26-33'),
    (3, '0.000', '399391', '2213'),
    (4, '0.000', '415209', '2302-06-32-33'),
    (5, '0.000', '415245', '2313'),
    (6, '0.000', '437273', 'ALL 24TH; 25TH; 26TH'),
    (7, '0.000', '436803', '2631 (BODY 2678); 5431 (BODY 5478)'),
    (8, '0.000', '448611', 'ALL 54TH'),
    (9, '0.0015', '372174', 'ALL 22ND; 23RD'),
    (10, '0.0015', '399324', '2201-02-11-20-22-32-40; 2301'),
    (11, '0.0015', '399324', '2206-13-26-33; 2302-06-13-32-33'),
    (12, '0.0015', '372146', 'ALL 22ND; 23RD'),
    (13, '0.0015', 'G179359', '2201-02-11-20-22-32-40; 2301'),
    (14, '0.0015', 'G179559', '2206-13-26-33; 2302-06-13-32-33'),
    (15, '0.0015', '422024', '2201-02-11-20-22-32-40; 2301'),
    (16, '0.0015', '422024', '2206-13-26-33; 2302-06-13-32-33'),
    (17, '0.0016', '378664', 'ALL 22ND; 23RD'),
    (18, '0.0016', 'G178532', 'ALL 22ND; 23RD'),
    (19, '0.0016', 'G123197', 'ALL 22ND; 23RD'),
    (20, '30.793', '448421', 'ALL 54TH'),
    (21, '30.7932', '422762', '2462-65-92-95-98; 2562-65-92-95; 2662-65-92-95'),
    (22, '30.7932', '448902', '5462-65-67-82-85-92-95-97'),
    (23, '30.7938', '399941', 'ALL 22ND; 23RD'),
    (24, '30.7938', '425809', 'ALL 24TH; 25TH; 26TH'),
    (25, '30.7938', '447799', 'ALL 54TH'),
    (26, '30.79383', '399927', 'ALL 22ND; 23RD; 24TH; 25TH; 26TH'),
    (27, '30.79396', 'PA437550', '2562-65-77-79; 2677-79'),
    (28, '30.79398', '422470', '2452-72; 2552-72'),
    (29, '30.79398', '422471', '2452-72; 2552-72'),
    (30, '30.79398', '422553', 'ALL 24TH; 25TH'),
    (31, '30.8007', '425517', '2413-52-62-65-67-72-92-95-98; 2552-62-65-72-77-92-95; 2650-51-52-62-65-72-77-92-95-97; 5450-51-52-62-65-67-72-77-82-85-92-95-97'),
    (32, '30.8007', '425920', 'RHD; 2462-65-92-95; 2562-65-92-95; 2662-65-92-95-97; 5462-65-82-85-92-95-97'),
    (33, '30.8044', 'G129662', '2293');
select  Id,GroupNumber,PartNo,
  group_concat(
    replace(t.part, '-', concat(' ', left(t.part, 2)))
    order by t.partno
    separator ' '                                      
  ) Models
from
(SELECT
  Id,GroupNumber,PartNo,
  SUBSTRING_INDEX(SUBSTRING_INDEX(models, ';', n.digit+1), ';', -1) part
FROM
  parts_listing
  INNER JOIN
  (SELECT 0 digit UNION ALL select 1 union all select 2 union all select 3 union all
    select 4 union all select 5 union all select 6 union all
    select 7 union all select 8 union all select 9) n
  ON LENGTH(REPLACE(Models, ';' , '')) <= LENGTH(Models)-n.digit
ORDER BY
  Id,
  n.digit) t
   Group by  Id,GroupNumber,PartNo;
 


Id
GroupNumber
PartNo
Models


1
0.000
391906
 2301 2201 2202 2211 2220 2222 2232 2240

2
0.000
391907
2206 2226 2233

3
0.000
399391
2213

4
0.000
415209
2302 2306 2332 2333

5
0.000
415245
2313

6
0.000
437273
 26TH  25TH ALL 24TH

7
0.000
436803
 5431 (BODY 5478) 2631 (BODY 2678)

8
0.000
448611
ALL 54TH

9
0.0015
372174
 23RD ALL 22ND

10
0.0015
399324
 2301 2201 2202 2211 2220 2222 2232 2240

11
0.0015
399324
 2302  206  213  232  233 2206 2213 2226 2233

12
0.0015
372146
 23RD ALL 22ND

13
0.0015
G179359
 2301 2201 2202 2211 2220 2222 2232 2240

14
0.0015
G179559
 2302  206  213  232  233 2206 2213 2226 2233

15
0.0015
422024
 2301 2201 2202 2211 2220 2222 2232 2240

16
0.0015
422024
 2302  206  213  232  233 2206 2213 2226 2233

17
0.0016
378664
 23RD ALL 22ND

18
0.0016
G178532
 23RD ALL 22ND

19
0.0016
G123197
 23RD ALL 22ND

20
30.793
448421
ALL 54TH

21
30.7932
422762
 2662  265  292  295  2562  265  292  295 2462 2465 2492 2495 2498

22
30.7932
448902
5462 5465 5467 5482 5485 5492 5495 5497

23
30.7938
399941
 23RD ALL 22ND

24
30.7938
425809
 26TH  25TH ALL 24TH

25
30.7938
447799
ALL 54TH

26
30.79383
399927
 26TH  25TH  24TH  23RD ALL 22ND

27
30.79396
PA437550
 2677  279 2562 2565 2577 2579

28
30.79398
422470
 2552  272 2452 2472

29
30.79398
422471
 2552  272 2452 2472

30
30.79398
422553
 25TH ALL 24TH

31
30.8007
425517
 5450  551  552  562  565  567  572  577  582  585  592  595  597  2650  251  252  262  265  272  277  292  295  297  2552  262  265  272  277  292  295 2413 2452 2462 2465 2467 2472 2492 2495 2498

32
30.8007
425920
 5462  565  582  585  592  595  597  2662  265  292  295  297  2562  265  292  295  2462  265  292  295 RHD

33
30.8044
G129662
2293

Id	GroupNumber	PartNo	Models
1	0.000	391906	2301 2201 2202 2211 2220 2222 2232 2240
2	0.000	391907	2206 2226 2233
3	0.000	399391	2213
4	0.000	415209	2302 2306 2332 2333
5	0.000	415245	2313
6	0.000	437273	26TH 25TH ALL 24TH
7	0.000	436803	5431 (BODY 5478) 2631 (BODY 2678)
8	0.000	448611	ALL 54TH
9	0.0015	372174	23RD ALL 22ND
10	0.0015	399324	2301 2201 2202 2211 2220 2222 2232 2240
11	0.0015	399324	2302 206 213 232 233 2206 2213 2226 2233
12	0.0015	372146	23RD ALL 22ND
13	0.0015	G179359	2301 2201 2202 2211 2220 2222 2232 2240
14	0.0015	G179559	2302 206 213 232 233 2206 2213 2226 2233
15	0.0015	422024	2301 2201 2202 2211 2220 2222 2232 2240
16	0.0015	422024	2302 206 213 232 233 2206 2213 2226 2233
17	0.0016	378664	23RD ALL 22ND
18	0.0016	G178532	23RD ALL 22ND
19	0.0016	G123197	23RD ALL 22ND
20	30.793	448421	ALL 54TH
21	30.7932	422762	2662 265 292 295 2562 265 292 295 2462 2465 2492 2495 2498
22	30.7932	448902	5462 5465 5467 5482 5485 5492 5495 5497
23	30.7938	399941	23RD ALL 22ND
24	30.7938	425809	26TH 25TH ALL 24TH
25	30.7938	447799	ALL 54TH
26	30.79383	399927	26TH 25TH 24TH 23RD ALL 22ND
27	30.79396	PA437550	2677 279 2562 2565 2577 2579
28	30.79398	422470	2552 272 2452 2472
29	30.79398	422471	2552 272 2452 2472
30	30.79398	422553	25TH ALL 24TH
31	30.8007	425517	5450 551 552 562 565 567 572 577 582 585 592 595 597 2650 251 252 262 265 272 277 292 295 297 2552 262 265 272 277 292 295 2413 2452 2462 2465 2467 2472 2492 2495 2498
32	30.8007	425920	5462 565 582 585 592 595 597 2662 265 292 295 297 2562 265 292 295 2462 265 292 295 RHD
33	30.8044	G129662	2293