parent child hierarchy

  1. O

    dependent dropdowns for child/parent table

    I have a table with a parent-child relationship and some other data: ChildParentInfo1…21…32…52…4512…5111…7211…722721…724721…1275721…1294721…13081…13091308…13111308…14601308…14791308…14931… In a tree format this would look like this: I want to have 3 dependent dropdowns, one for each level...
  2. M

    Power Query split?

    I have a table with a column that has full paths/categories on it: BaseCategory/SubCategoryA/SubCategoryA.1/SubCategoryA.1.1 OtherBaseCategory/SubCategoryB/SubCategoryB.1 How can I split the paths/categories using Power Query so that I can get all the previous categories as well: Full...
    • Misca
    • Thread
    • hierarchies parent child hierarchy power query split cell contents
    • Replies: 6
    • Forum: Power Tools
  3. S

    Create Parent Child relationship in Excel

    Hi, I'm new to Excel Scripting. I need help to create below parent child relationship in excel. I have the source file in below format. <colgroup><col span="4"></colgroup><tbody> Level1 Level2 Level3 Level4 PC_BMROA CD_KENBM 24158 009 PC_BMROA CD_KENBM 24158 010 PC_BMROA CD_KENBM...
  4. G

    Multiple child Parent relation hierarchy.

    Hi, I wanted to create a Hierarchy, which can contain multiple parent and child. Input Data :- <tbody> Role 1 2 3 4 5 6 7 8 9 A R R R R B R R R R R R C R R R R R R R D R R R R E R R R R R R R F R R R R R </tbody> Role A - 1,2,3,4 So each Role is formed with...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top