Forum Discussion
irfan_abdrhman
Helper II
Helper IILinking Children with Parent
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 ...
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
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