mdavy86/Reverse Pivot in Excel

## Reverse Pivot in Excel
- Click anywhere within the data table
- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon)
- Select "Multiple consolidation ranges" and click Next
- Select "I will create the page fields" and click Next
- Select your data table (in the example it's A1:E11)  and click Next
- Select the location and click Next
Now you will see a pivot table that looks just like your data table
- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present)
- Now select the cell with the single remaining total number and double click it.
The result is a new sheet with your data laid out one item per row.
	- Click anywhere within the data table
	- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon)
	- Select "Multiple consolidation ranges" and click Next
	- Select "I will create the page fields" and click Next
	- Select your data table (in the example it's A1:E11) and click Next
	- Select the location and click Next
	Now you will see a pivot table that looks just like your data table
	- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present)
	- Now select the cell with the single remaining total number and double click it.
	The result is a new sheet with your data laid out one item per row.