Sap Hierarchy Excel | Instant

: Select the column, click the yellow warning icon, and select Convert to Number .

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 Hierarchy Excel

: Use the LEN() and TRIM() functions to determine the level based on indentation. : Select the column, click the yellow warning