: 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.
Example: =LEN(A2)-LEN(TRIM(A2)) will tell you how many leading spaces exist, which usually corresponds to the hierarchy depth. Sap Hierarchy Excel
: Right-click your Cross Tab > User Options . : SAP hierarchies often show the same "Leaf"
SAP exports often come with "Green Triangle" errors (numbers stored as text). 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