MySQL 8.0

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

CREATE TABLE Table_A
    (`Submission_id` int, `Salesman` varchar(9), `Customer name` varchar(9), `Hobby` varchar(13), `Carline` varchar(9), `Fuel` varchar(5), `Marketing_data` varchar(24))
;
    
INSERT INTO Table_A
    (`Submission_id`, `Salesman`, `Customer name`, `Hobby`, `Carline`, `Fuel`, `Marketing_data`)
VALUES
    (1, 'salesman1', 'customer1', 'hobby1', 'car1,car2', 'Fuel1', 'hobby1,car1,car2,Fuel1'),
    (2, 'salesman2', 'customer2', 'hobby1,hobby2', 'car1', 'Fuel2', 'hobby1,hobby2,car1,Fuel2')
;
CREATE TABLE Table_B
    (`option_value` varchar(6), `option_name` varchar(8))
;
    
INSERT INTO Table_B
    (`option_value`, `option_name`)
VALUES
    ('hobby1', 'Football'),
    ('hobby2', 'Golf'),
    ('car1', 'SUV'),
    ('car2', 'Cabrio'),
    ('Fuel1', 'Gas'),
    ('Fuel2', 'Hybrid')
;
SELECT GROUP_CONCAT(DISTINCT c0.option_name)Marketing_data
FROM Table_A d
JOIN Table_B c0 ON FIND_IN_SET(c0.option_value, d.Marketing_data)
GROUP BY d.Marketing_data;


Marketing_data


Cabrio,Football,Gas,SUV

Football,Golf,Hybrid,SUV


UPDATE 
Table_A a
SET `Marketing_data` = (SELECT GROUP_CONCAT(DISTINCT c0.option_name)Marketing_data
FROM (SELECT * FROM Table_A) d
JOIN Table_B c0 ON FIND_IN_SET(c0.option_value, d.Marketing_data)
 WHERE a.`Submission_id` = d.`Submission_id`
 GROUP BY d.Marketing_data)
SELECT * FROM Table_A;


Submission_id
Salesman
Customer name
Hobby
Carline
Fuel
Marketing_data


1
salesman1
customer1
hobby1
car1,car2
Fuel1
Cabrio,Football,Gas,SUV

2
salesman2
customer2
hobby1,hobby2
car1
Fuel2
Football,Golf,Hybrid,SUV

Submission_id	Salesman	Customer name	Hobby	Carline	Fuel	Marketing_data
1	salesman1	customer1	hobby1	car1,car2	Fuel1	Cabrio,Football,Gas,SUV
2	salesman2	customer2	hobby1,hobby2	car1	Fuel2	Football,Golf,Hybrid,SUV