MySQL 8.0

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

CREATE TABLE tablename 
(
    id int,
    groupcol varchar(255),
    work_place varchar(255)
);
INSERT INTO tablename
VALUES      
(1, 'TTL', 'aa ee ii mm'),
(2, 'TTL', 'bb ff jj nn qq ss uu'),
(3, 'TTL', 'cc gg kk oo rr tt vv ww xx yy zz'),
(4, 'PFF', 'dd hh ll pp');  
SELECT *
FROM tablename


id
groupcol
work_place


1
TTL
aa ee ii mm

2
TTL
bb ff jj nn qq ss uu

3
TTL
cc gg kk oo rr tt vv ww xx yy zz

4
PFF
dd hh ll pp


SELECT id, groupcol, col
FROM   (SELECT id,
               groupcol,
               SUBSTRING_INDEX(work_place, " ", 1) AS col
        FROM   tablename
        WHERE  SUBSTRING_INDEX(work_place, " ", 1) != work_place

        UNION ALL

        SELECT id,
               groupcol,
               SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 2), " ", -1) AS col
        FROM   tablename
        WHERE  SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 2), " ", -1) != work_place

        UNION ALL

        SELECT id,
               groupcol,
               SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 3), " ", -1) AS col
        FROM   tablename
        WHERE  SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 3), " ", -1) != work_place

        UNION ALL

        SELECT id,
               groupcol,
               SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 4), " ", -1) AS col
        FROM   tablename
        WHERE  SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 4), " ", -1) != work_place

        UNION ALL

        SELECT id,
               groupcol,
               SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 5), " ", -1) AS col
        FROM   tablename
        WHERE  SUBSTRING_INDEX(SUBSTRING_INDEX(work_place, " ", 5), " ", -1) != work_place) tmp
group  BY id, groupcol, col  


id
groupcol
col


1
TTL
aa

2
TTL
bb

3
TTL
cc

4
PFF
dd

1
TTL
ee

2
TTL
ff

3
TTL
gg

4
PFF
hh

1
TTL
ii

2
TTL
jj

3
TTL
kk

4
PFF
ll

1
TTL
mm

2
TTL
nn

3
TTL
oo

4
PFF
pp

2
TTL
qq

3
TTL
rr

id	groupcol	work_place
1	TTL	aa ee ii mm
2	TTL	bb ff jj nn qq ss uu
3	TTL	cc gg kk oo rr tt vv ww xx yy zz
4	PFF	dd hh ll pp

id	groupcol	col
1	TTL	aa
2	TTL	bb
3	TTL	cc
4	PFF	dd
1	TTL	ee
2	TTL	ff
3	TTL	gg
4	PFF	hh
1	TTL	ii
2	TTL	jj
3	TTL	kk
4	PFF	ll
1	TTL	mm
2	TTL	nn
3	TTL	oo
4	PFF	pp
2	TTL	qq
3	TTL	rr

id	groupcol	col
1	TTL	aa
2	TTL	bb
3	TTL	cc
4	PFF	dd
1	TTL	ee
2	TTL	ff
3	TTL	gg
4	PFF	hh
1	TTL	ii
2	TTL	jj
3	TTL	kk
4	PFF	ll
1	TTL	mm
2	TTL	nn
3	TTL	oo
4	PFF	pp
2	TTL	qq
3	TTL	rr

id	groupcol	col
1	TTL	aa
2	TTL	bb
3	TTL	cc
4	PFF	dd
1	TTL	ee
2	TTL	ff
3	TTL	gg
4	PFF	hh
1	TTL	ii
2	TTL	jj
3	TTL	kk
4	PFF	ll
1	TTL	mm
2	TTL	nn
3	TTL	oo
4	PFF	pp
2	TTL	qq
3	TTL	rr