: Go to the Components tab. You can toggle between "Show Hierarchy" (stepped) or "Flat Presentation."
If you don't want to use Power Query, you can use formulas to "flatten" the hierarchy manually. Sap Hierarchy Excel
: SAP hierarchies often show the same "Leaf" node under multiple "Nodes." Use Data > Remove Duplicates if you are trying to get a unique list of accounts. : Go to the Components tab
Example: =LEN(A2)-LEN(TRIM(A2)) will tell you how many leading spaces exist, which usually corresponds to the hierarchy depth. Sap Hierarchy Excel