If you analyse data in Excel you know that Pivot Tables are magic and that they are generated from simple lists of records (“facts”). Unfortunately very often you data will be given to you by a user who has put it into Crosstab format and to get this back into a list you have to manually cut and paste data, use a VBA macro or use a plugin such as KuTools.

Until now!

Here is a great video that shows you how to do it using Excel’s built-in functionality. The world is suddenly a better place.

Thanks to my colleague Andrew Storey for this tip.