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
9 answers
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
