Filling column with another value in the same column but different row

[Pillz_]

I have a table that contains main jobs and sub jobs that are related to the main jobs. I'm trying to create a filter that contains the concatenation of the job code and the respective job name. This will be the Job Combined column. Based on the current photos of the mock tables, is there a way to change the Job Combined Table to only contain the parent job names and not the sub job names?

Current table layout

What I want 

[parry2k]

@HotChilli Do you want to assist @Pillz_  here, if not then I can take care of it. Cheers!!

[HotChilli · Accepted solution]

Is there a column which indicates the Parent Jobs?

If so, and the Jobs and SubJobs are in order this can probably be done in Power Query in a straightforward manner - create a column on the Parent Jobs to give the 'Job Combined' then do a Fill Down on the column.

If they are not in order, there needs to be a column on the subjobs which shows which is the parent.  Then use M or DAX to get the JOb Combined from the parent.

[Pillz_]

See my reply to @parry2k below with the updated table mockup containing a hierarchy for the jobs

[parry2k]

@Pillz_ it can be done but from the mock-up, it is not clear how sub-jobs are related to parent job, I don't see any logic or pattern in it.

[Pillz_]

Forgot to include in the table but there is a column called Hierachy that tracks the hierarchy level. I've also found out that some of these sub jobs also have sub jobs within them. Here's a new mockup for the table