In many organisations, users have to contend with reports and forms that were designed – literally – in the last century. I was recently asked to help a user with one of these.

In the attached file you will see what it looked like at the beginning (see Original tab) and in the Cleaned version it’s now ready for human consumption. That took about 6 minutes in Power Query. If you want to do that manually – it would be more like an hour or more…

Download the file here

You can see a video of it here.

Note that I did this in Office 365 but if you wanted to do it in Excel 2010, you would have to install it first and this may take Administrator permissions depending on your organisation.

I hope you found this useful