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