Fix Excel Data for Better Pivot Tables - Normalize - UnPivot

Before you create an Excel pivot table, make sure your data is set up correctly. The data should be normalized, with similar data in a single column, instead of divided into many columns.

To fix the data, if your data has amounts in monthly or yearly columns, you can use this simple trick to rearrange it.

This technique use a multiple consolidation ranges pivot table, to convert the data with a few clicks.

Then, instead of one column for each month, you will have a single column, with the month name for each record, and another column with the amount.

Watch this Excel tutorial video, to see the steps for normalizing your data, and preparing it for use in an Excel pivot table.

For written steps, and the Excel sample file, go to my Contextures site:
https://www.contextures.com/excelpivo...

Video Timeline
00:00 Excel Data Across Columns
00:26 Pivot Table Problem
01:12 Start Multiple Consolidation Steps
02:13 Unpivot the Pivot Table
02:46 Make Pivot Table from Unpivot Data
03:30 Data with Multiple Labels
05:35 Pivot Table from Revised Data