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.