In this experiment I decided to see what would happen if I asked it to get my data pivot table ready. So I gave it a sample download – very typical of an accounting system data dump (I actually got this from QuickBooks). It did a great job – filled in fields and it was ready to pivot – much quicker than if I had to do it manually.
You can view the original file here
You can see the cleaned up file here – the final version.