Hierarchy in Power Query Editor

[carmel_owen]

I am trying to create a table from data that already has parent details in it, with the aim that there is a text value for each level of the hierarchy, for each 'Name'- I don't know if its my logic thats at fault, or maybe I need to do some further modelling, but I can't work out what to do without doing a massive IF statement for each column? 

Below is an example of my table with the data that is already present from the datasource. The 'ID' and the 'Name' columns are unique and I ultimately want for example, for a Level 7 name, the level 6 column should have the name that matches Level 6 for the Parent 6 column, then Level 5 would have the name that matches Parent 5 etc etc. So then when I use a slicer it will have those hierachy steps in? Those columns are currently blank, and I can't work out how to fill them, fill down won't work as the names need to be connected to the 'Parent' column. 

[carmel_owen]

ID

Parent 1

Parent 2

Parent 3

Parent 4

Parent 5

Level

Name

Level 7

Level 6

Level 5

Level 4

Level 3

Level 2

Level 1

10000

PHL-A-10

PHL-A-10-10

PHL-A-10-10-10

PHL-A-10-10-10-10

PHL-A-10-10-10-10-1000

6

tdlnt tdlcdlivcxbldl

null

tdlnt tdlcdlivcxbldl

null

null

null

null

null

10900

PHL-A-10

PHL-A-10-10

PHL-A-10-10-10

PHL-A-10-10-10-20

PHL-A-10-10-10-20-1090

7

dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl

dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl

null

null

null

null

null

null

25000

Unassigned

2

Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl

null

null

null

null

null

Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl

null

63100

PHL-A-10

PHL-A-10-10

PHL-A-10-10-40

PHL-A-10-10-40-10

PHL-A-10-10-40-10-6310

5

Scxldl Ptpkcdldlds - Hpkusing  Ptpkpdlttidls

null

null

Scxldl Ptpkcdldlds - Hpkusing  Ptpkpdlttidls

null

null

null

null

null

[Account]

1

Npkt cxppliccxbldl

null

null

null

null

null

null

Npkt cxppliccxbldl

null

PHL-A-10

PHL-A-10

3

pkpdltcxting Sutplus

null

null

null

null

pkpdltcxting Sutplus

null

null

null

PHL-A-10

PHL-A-10-10

PHL-A-10-10

4

Tutnpkvdlt

null

null

null

Tutnpkvdlt

null

null

null