Multi Level Parent Child Hierarchy

Alright then. Let's try this...

For the dataset

add the [Child] column as a new query and remove duplicates

now test the [Parent] column to see if the value is a "master" parent

Table.AddColumn(#"Changed Type1", "masterParent", each if List.Contains(Child, [Parent]) then null else [Parent])

Fill down the [masterParent] column

Table.FillDown(#"Added Custom",{"masterParent"})

Group By [masterParent] and [Parent] with now aggregation of rows

Table.Group(#"Filled Down", {"Parent", "masterParent"}, {{"Group1", each _, type table [Parent=nullable text, Child=nullable text, master=text]}})

Now Group By [masterParent] with no aggregation

Table.Group(#"Grouped Rows", {"masterParent"}, {{"Group2", each _, type table [Parent=nullable text, master=text, Count=table]}})

Add an index column

Table.AddColumn(#"Grouped Rows1", "Index", each Table.AddIndexColumn([Group2], "Index", 1))

Remove the [masterParent] and [Group2] columns

Table.RemoveColumns(#"Added Custom1",{"masterParent", "Group2"})

expand the [Index] column

Table.ExpandTableColumn(#"Removed Columns", "Index", {"Parent", "masterParent", "Group1", "Index"}, {"Parent", "masterParent", "Group1", "Index"})

remove the [Parent] and [masterParent] columns

Table.RemoveColumns(#"Expanded Custom",{"Parent", "masterParent"})

expand [Group1] column

Table.ExpandTableColumn(#"Removed Columns1", "Group1", {"Parent", "Child", "masterParent"}, {"Parent", "Child", "masterParent"})

add a Prefix to the [Index] column

Table.TransformColumns(#"Expanded Count", {{"Index", each "Level " & Text.From(_, "en-US"), type text}})

add a boolean true column

Table.AddColumn(#"Added Prefix", "_boolean", each true)

add the [Index] column as a new query and remove duplicates

pivot the [Index] column using the [_boolean] column as values with no row aggregation

Table.Pivot(#"Added Custom2", List.Distinct(#"Added Custom2"[Index]), "Index", "_boolean")

replace the null values with "FALSE", using the Index list to ensure it will work dynamically

Table.ReplaceValue(#"Pivoted Column",null,false,Replacer.ReplaceValue,Index)

and finally remove the [masterParent] column

Table.RemoveColumns(#"Replaced Value",{"masterParent"})

Hope this helps!