: Go to the Data tab > Get Data > From File > From Workbook/Text and select your SAP export.
: Right-click your Cross Tab > User Options . Sap Hierarchy Excel
: Go to the Components tab. You can toggle between "Show Hierarchy" (stepped) or "Flat Presentation." : Go to the Data tab > Get