mysql – How to insert multiple values ​​in a single column?

In my database there were 39000 rows and the following code just to give you an idea of ​​what kind of data is in the NAMES table:

Insert into NAMES (NAME_ID,PROFESSION1,PROFESSION2,PROFESSION3) values ('nm0000113','producer','actress','soundtrack');
Insert into NAMES (NAME_ID,PROFESSION1,PROFESSION2,PROFESSION3) values ('nm0000114','actor','director','producer');
Insert into NAMES (NAME_ID,PROFESSION1,PROFESSION2,PROFESSION3) values ('nm0000119','actress','soundtrack','producer');
Insert into NAMES (NAME_ID,PROFESSION1,PROFESSION2,PROFESSION3) values ('nm0000120','actor','writer','producer');

The table from which I want to take the data:

CREATE TABLE NAMES (
NAME_ID varchar(9),
PROFESSION1 varchar(255),
PROFESSION2 varchar(255),
PROFESSION3 varchar(30),
);

The table into which I want to insert the data:

CREATE TABLE PROFFESION(
PROFFESION_ID INT PRIMARY Key,
PROFFESION VARCHAR (30)
);

The embed code:

Insert into PROFFESION(PROFFESION_ID, PROFFESION)
Select seq_person.nextval, PROFESSION1, PROFESSION2, PROFESSION3 from NAMES;

I want to take the data from the NAMES table and store it in the PROFESSION table, but I want all PROFESSIONS 1, 2, 3 to be stored in PROFESSION. Is it possible to do that?