I am new to VB, saw your post on providing parent child hierarchy in visually structured way in excel. Hoping that you will help me out in this issue .
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