PLEASE HELP ME OUT Parent-Child hierarchy construction

  • Hi,
    I am new to VB, saw ur post on providing parent child hierarchy in visually structured way in excel. Hoping that you will help me out in this issue . Please mail me in



    [email protected]



    There is a table in xl as below:
    Calling Called
    Folder1 Sub1
    Folder1 Sub2
    Sub1 Sub3
    Sub3 Sub4
    Folder2 Sub6
    Folder2 Sub7
    Sub7 Sub8
    Sub7 Sub9



    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:
    Folder1->Sub1->Sub3->Sub4
    Folder1->Sub2
    Folder2->Sub6
    Folder2->Sub7->Sub8
    Folder2->Sub7->Sub9



    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|...):
    Folder1|Sub1
    Folder1|Sub2
    Folder1|Sub1|Sub3
    Folder1|Sub1|Sub3|Sub4
    Folder2|Sub6
    Folder2|Sub7
    Folder2|Sub7|Sub8
    Folder2|Sub7|Sub9



    Please help me out in this. Thanks

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Posting your email address only helps spammers, all questions & answers should be kept to the Forum.

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    If you are new to VBA you'd better start with something in accordance of your abilities. Your question isn't.

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Hi,


    There is a DAX path() function available in excel 2013 ,as mentioned in the below link:
    http://office.microsoft.com/en…s-in-dax-HA102839072.aspx
    If you refer the PATH column , i need my output like this.


    I installed Office 2013 trial version and strangely found that I cannot use this function.And there is no useful link of detailed explanation of using this function.
    If there is any link where-in in VBA it is available as my expected output is ,please guide me. thanks ..

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    It clearly states that it is for Excel 2013 with PowerPivot, which is a separate Excel addin.


    I would also think that you need the full version of Excel

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Hi,

    I have installed Office 2013..I am not aware of using Powerpivot, learning and trying now takes more time. Would help if you help me out on this.

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Hi,

    I have installed Office 2013..I am not aware of using Powerpivot, learning and trying now takes more time. Would help if you help me out on this.

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Appreciate your thoughts on not helping. It was a urgent requirement and hence was requesting that did anybody tried in their projects..

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Not too sure exactly what you mean in your reply, but the fact it was an urgent requirement on your part does not excuse you ignoring one of the cardinal rules when posting on boards such as this... If you post the same issue on multiple boards, then at least have the courtesy to let people know .


    Have a happy and peaceful Christmas (if that' happens to be your thing).

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Disha


    Please follow the rules, both implicit and explicit rules:


    - no cross-posting. Urgency is not an excuse for cross-posting. At the very least, tell helpers about it.
    - no useless words or phrases in the topic title. For example, PLEASE HELP ME is absolutely useless information.
    - You posted twice the same reply in this topic. You could have deleted one of the 2.
    - If you absolutely don't know what you are talking about, please take the time to build up knowledge before doing thses non-trivial exercises. If you're new to VB and VBA, do the simple stuff first and do not expect an answer if you do not spend any effort yourself.


    Let me be clear, if you do not pay attention to what I wrote here, your stay at Ozgrid will not last very long.
    However, if you do follow this, we are glad to have you on board.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: PLEASE HELP ME OUT Parent-Child hierarchy construction


    Topic closed and user will be watched in future for obeying rules.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --