Hi experts!
I'm trying to traverse and convert a Parent|Child file into a separate hierarchy, with a header.
The 'depth' of the Parent|Child relationships is yet unknown, so the output could stretch to many columns on the right.
I have tried coding for just two input columns, with little...
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...
dear all!
I've downloaded a balance sheet of SAP, in with all positions are lined up without hierarchie. In a seperate collum are Hierarchie levels asigned. I'm trying to allocate the hierarchie levels to the balance sheet line items to be able to work with it in a Pivot.
the raw data lists...
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.