To get a row for a single job you can create a union with a branch for every column. In this case, job_1, job_2, and job_3 will be transformed into the column jobs in a new view.
In order to do that, in this case, the easiest way is to create the view manually using VQL
CREATE VIEW dv_multiple_jobs AS
SELECT name, job_1 as jobs FROM bv_multiple_jobs WHERE job_1 <> ''
SELECT name, job_2 as jobs FROM bv_multiple_jobs WHERE job_2 <> ''
SELECT name, job_3 as jobs FROM bv_multiple_jobs WHERE job_3 <> ''
You can also do this graphically, by creating a projection view for every branch and then create the view:
Create a projection view for every branch maintaining Name column and one of the job columns for each view.
Every view will have a condition for empty values for the same column that you are projecting on the view.
Create a Union View using those projections and include an association for the JobX fields
Execute the view and you will get the expected results.
Hope this helps!