I have a suspicion it won't work in 2003. If the data is not sensitive, and this is a one off, I'd be more than happy to reshape it for you.
I have the same problem. I opened a ticket with Tableau hotline months ago, but it's not solved yet. In my case, I think it's not Excel version related (2003-2007-2010), but linked with Windows localization.
I have a "French" version of Windows 7 Pro and I have frequently the bug with Excel macros developped in the US.
Thank you very much, but the data is sensitive.
A new try without solution:
we are using multi-language Win XP
- we changed the setting from Hungarian to English - it doesn't solved the problem
- we uninstalled the multilanguage function, only the English remained - no changes :-(((
The re-shape tool works fine if I change the "Regional settings" from Hungarian to English (US).
It is only a temporely solution, because all of the regional important settings changed, like number format, currency, date, time forms.
Changing localization (regional settings) from French to English US solve the problem too.
Try Pivot Table Multiple Consolidation Range.
You can create pivot table from a flat crosstab.
Then when you have the pivot table, click the bottom-right cell (Grand Total), Excel will generate the underlying data -> data reshaped!