Hi all,
I am a new user of Tableau. I have data in native excel format as below.
I would like to flatten in the following format for use in Tableau. I have hit a roadblock. Can anyone help?
Thanks!
Shriram
Mar 10, 2017 5:20 AM
Good morning
You can pivot the data after it loads
see the link below
Process is easily done -
After loading go to the data source tab
Click on all the columns you want to include in the pivot
Right click the header and select Pivot Data
and you are there
Let me know if this helped
Jim
Hi Shriram,
I would create two tables in excel (one with population and City, another with city and state). Unpivot both of them to suit my need and then blend them in Tableau view.
BR
Sharad
Sharad Adhikari Jim Dehner thanks for the ideas. I have been diddling around and what worked the best is to simple transpose the data I have. And then proceed to unpivot in a normal manner.
So reformat native Excel data to following by transposing:
Mar 10, 2017 5:54 AM
This would work well to meet your need
Jim