You’ve heard of Pivot! Now let me introduce you to Unpivot!

Often when we get data it’s done in the format as seen below

However quite often we need it to be organised differently – for example if I want to set this up to be able to calculate the monthly total for each product in a pivot table – not really possible as it.

So I need to unpivot the data.. this video shows you how to do it. You can download the original file here.