how to convert multiple column data into two columns

Hi all,
I am new to excel sheet. I have data like Jobs which are mapped to Roles.
Jobs are in first column and roles are mapped to multiple columns to jobs.
few columns have empty values. So now i want to make result exact to two columns
first column is Jobs and second column is roles mapped to it. Attachment 682294
for more details pls see attached image.

how to achieve this ?

Regards
Alena