Have you ever needed to flatten a table, meaning a table with multiple columns of data, that you wanted to run a pivot off of?
Check this out.
The time savings: You do not have to copy each column of values at the bottom of your table to flatten manually. This is a SICK trick. One of my favorites. Saved me almost an hour.
Design by Simon Fletcher. Powered by Tumblr.
© Copyright 2010