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.
Here's the link: http://www.tableausoftware.com/about/blog/2012/03/reshaping-data-made-easy-16353
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.
--Shawn
Message was edited by: Shawn Wallwork
Become a Viz Whiz on the Forums! Support the Community and master Tableau.