: When running the report in SAP (e.g., transaction KSR3 or OKP3 ), look for an export option called "Grids" or "ALV Layout" . These are much easier to work with in Excel than "Classic" SAP layouts.
: If SAP exports levels in a single column with spaces (indentation), use Split Column > By Number of Characters or By Delimiter to separate levels into distinct columns. 2. Standard Excel Formulas Sap Hierarchy Excel
: Go to the Components tab. You can toggle between "Show Hierarchy" (stepped) or "Flat Presentation." : When running the report in SAP (e
If you don't want to use Power Query, you can use formulas to "flatten" the hierarchy manually. transaction KSR3 or OKP3 )