PLEASE HELP ME OUT Parent-Child hierarchy construction
There is a table in xl as below:
Explaination of the table:
"Folder1" is calling child "Sub1" and "Sub1" is calling "Sub3", and likewise ...
I need an output in an hierarchy saying parent->child->subchild...
Expected Output 1:
Expected Output 2:
In the 3rd column of excel against each row of Calling & Called columns ,Output should be as below(i.e, Parent|Child|...):
Please help me out in this. Thanks
Re: PLEASE HELP ME OUT Parent-Child hierarchy construction