This content has been marked as final.
Show 7 replies
-
1. Re: Normalizing (or pivoting) data using Tableau?
Shawn Wallwork Feb 15, 2013 12:10 PM (in response to Armando Ramirez)Hi Armando, would you post that first table as an Excel file. Thanks,
--Shawn
-
2. Re: Normalizing (or pivoting) data using Tableau?
Armando Ramirez Feb 15, 2013 12:17 PM (in response to Shawn Wallwork)Sure
Please find attached
-
Test.xlsx 9.3 KB
-
-
3. Re: Normalizing (or pivoting) data using Tableau?
Shawn Wallwork Feb 15, 2013 12:34 PM (in response to Armando Ramirez)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
-
Test-SW.xlsx 13.2 KB
-
-
4. Re: Normalizing (or pivoting) data using Tableau?
Armando Ramirez Feb 15, 2013 12:51 PM (in response to Shawn Wallwork) -
5. Re: Normalizing (or pivoting) data using Tableau?
Shawn Wallwork Feb 15, 2013 1:20 PM (in response to Armando Ramirez)What release (year) is your Excel?
-
6. Re: Normalizing (or pivoting) data using Tableau?
Armando Ramirez Feb 15, 2013 1:32 PM (in response to Shawn Wallwork)mh Office 2007?
-
7. Re: Normalizing (or pivoting) data using Tableau?
Shawn Wallwork Feb 15, 2013 1:37 PM (in response to Armando Ramirez)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