Depending on the data source you are using, you can pivot those two columns into one. On the EDIT DATA SOURCE screen, highlight both the columns. (Shift click each one). Then on one of the highlighted columns, right click in the header of the column. If you get PIVOT as an option, that's what you need to do.
(If not, then you need to ETL the data before feeding it to Tableau and to the same function in whatever native utilities you have for that data source.)
1 of 1 people found this helpful
Just to add one thing to Joe's comment. Pivot is only available in a few different data source types, but with Tableau Prep, you can pivot just about anything. You can also pivot using custom SQL (for some database platforms). I wrote about these options here: 3 Ways to Pivot Data for Tableau - Ken Flerlage: Analytics Architecture, Strategy, & Visualization
Totally what we need, thanks!!