Thanks, but I don't even see pivot data as an option when I follow the instructions in that article. Not sure if that's an old article that does not apply to Tableau Desktop 10.4 or if it's just not working with my data. Or, maybe because I'm using a Mac. I'll get some mock data together and post it.
If you are not seeing pivot as an option then it could be your data source - data from some data sources can not be pivoted in tableau -
consider that when you provide some dummy data - if it is a simple excel sheet that can be pivoted you may not get a good answer
This week tableau introduced Tableau Prep which may be able to pivot that data
see the link Tableau Prep: A new data preparation solution
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks, Jim. I downloaded Tableau Prep yesterday so I'm exploring that now. Hopefully it will help.