Chris Cox/April 29, 2014/

At the 2014 Partner Summit, I was reminded about the Tableau Reshaping Add-In for Excel. This is a great tool, but if your data set only changes slightly, you still have to re-run the macro on every row. I developed a formula based alternative to the macro driven re-shaper that solves the same data layout issue, but works quicker in most situations.

As I continue my training, I am reminded that knowledge sharing is an important trait of the Jedi.

This Excel file is built off a handy data set of Population Data that I typically use to demo Data Blending. To see it work, just add a new “State” to cell A53 on the Main Tab, and that row will appear (with the corresponding values) on rows 53, 105, etc. on the Tableau Ready Tab.

 

 

Boulder Insight Updates!
Get actionable and on-the-court Tableau pointers delivered direct to your inbox. No SPAM guarantee.