Finding name Top Parent Name for Sub-Child in Power Query

[Praiciya-07]

Hi All,
I am having Table like the below image in the Power Query , 

I need to find a result like this , Finding top parent name for each childs in Power Query.

[amitchandak]

@Praiciya-07 , The best duplicate the table and remove columns other than Object id and name and remove duplicates and then use merge query and join the parent id of the current table with the object id of new table.

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

[Praiciya-07]

Result is not coming as per the expection uisng above method, any other way to find