Flatten a pivot table in Excel

This is another trick gleaned from exploring data to be imported to a Data Warehouse from an Excel spreadsheet.

Sometimes we are provided data in a pivot table, which is not the most useful format for exploration or extraction, particularly because all the row labels are in the same column by default.

In order to make the format more usable, it’s possible to “flatten” the pivot table in Excel. To do this, click anywhere on the pivot table to activate the PivotTable Tools menu. Click Design, then Report Layout & then Show in Tabular Form.

This will separate out the row labels & make it easier to explore data.