Linking Children with Parent

[irfan_abdrhman]

Hello Community,

Here is the Source Data where I'm currently stuck at,

So the idea is that the Number column represents the Parent, and the Expense Items.Number represents the children. So the data is messed, we cannot tie back one to one. 

First Issue - Linking Children with Respective Parent.
The Name column can be used as an identifier as for the children, In the Name column it will be duplicated accordingly, but in the Number column, we can see that it has blanks. I already have a combined Name column called Expense Name which combines the Name and Expense Items.Name. So for now, I just want the children to be right below the parents, as i want the visualization in dashboard to be - Number, Expense Items.Number, Expense Name and etc. Please see the copied power query table in the excel sheet at the top, "Source Data". Thank you all.

Second Issue - Sorting the Data

As you can see, the Data is not in a proper sequence because the Number is different but can still be seen which one comes first, So is there any way to address this? Please skip if no. I'll use the usual create new column and sort by the column. Thank you

[Anonymous]

Hi @irfan_abdrhman ,

Did p45cal's reply help you?

If so, please accpet the reply as a solution. More people will benefit from it.

Best Regards,

Stephen Tao

[p45cal · Accepted solution]

See if the table at cell BA3 in the linked-to workbook below is any help at all.

See last column and I've sorted on it (on the sheet, not in PQ).

The only bug is with Cement-OPC which has 2 parents.

Hopefully there is only one level of child (children don't have their own children).

The workbook: https://app.box.com/s/qnwb56ggi80y0f0l3cdzmg9z23osaonu

[irfan_abdrhman]

Would you by any chance know how to visualize this? on the dashboard (Table)