Power Query get name from another row in table

[ruthhacche]

I want to add a column to the table below with the parent name using the parent id and then delete the parent rows and parentID column to give the second table. What is the best way of getting the parent name into a column? Any pointers gratefully received.

 

[sandy666]

use xl2bb to post your example not a picture

 

[veyselemre]

Could you please delete it, it was wrong.

 

[veyselemre]

Hi,

let
    Source= Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Join = Table.NestedJoin(Source,{"PARENT ID"},Source,{"ID"},"Table",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Join, "Table", {"NAME"}, {"PARENT NAME"}),
    RC = Table.RemoveColumns(Expand,{"PARENT ID"})
in
   RC