This video shows how you can spin and clean a ‘messy’ dataset that clearly has structure in addition to making use of parameterised filtering. The dataset in question shows a series of dates within history going back 2000 years so you may learn something along the way 🙂

All of this is available within excel so please dig in.

The source files are contained here :-

You can download power query (Excel 2013) here:


If you have Excel 2016 you should not need to do any downloads.

Please drop me feedback if you find this useful.

source TDG/Data Spinners

Subscribe to Rory’s channel

Choose your Reaction!
Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.