This is the most "future-proof" way to handle SAP exports. It transforms a visual hierarchy into a flat table where every row has its parent levels defined.
: SAP exports usually include "Total" rows. Use the filter dropdown on your "Account" or "Cost Center" column to uncheck any rows containing "Total" or "Result." Sap Hierarchy Excel
: 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 This is the most "future-proof" way to handle SAP exports
: Right-click your Cross Tab > User Options . Sap Hierarchy Excel