Hi
IsAny thought on how to accomplish the following?:
1) Original Excel data format as shown below:
2) Desired format and ideally desired to be done somehow using Tableau:
3) Even better, if possible:
Regards
Hi Armando, would you post that first table as an Excel file. Thanks,
--Shawn
OK, what you're really going to want to do is download and install the Excel Reshaper Plug-in. Once you do that you're just a few clicks away from having your data shaped the way you want it.
See attached. Note: to get this exact result you'll need to add an extra header row before doing the reshape like I did in Hoja1(2).
--Shawn
Thanks Shawn!
that's exactly what I need...
However, I downloaded and Installed the Add In, and it is NOT shown in the Excel/Options/Go menu as shown below:
Do you know which folder is the Add In installed?? thanks
Well that's good. It should work with 2007. This might be a question for Andy since he's the guy that wrote this unsupported add-in. I just pinged him, let's see if he has any suggestions.
--Shawn