In case you missed it, Tableau released the latest version of the Excel Reshaper tool. Thanks guys! FYI: It seems to only work with Excel 2007-2010, which is great for me, because I now have a reason to upgrade. So double-thanks. Update: It also works with Excel 2013.
ALTERNATE OPTION: You can also do the same thing on the fly using Custom SQL. kettan and Jonathan Drummey have provided two different versions of how to do this here: http://community.tableau.com/message/217515#217515 I would have added this to Ross's blog but they've closed comments.
Message was edited by: Shawn Wallwork