If I understand correctly, it sounds like you just need to pivot those three sets of fields. If so, please take a look at this: 3 Ways to Pivot Data for Tableau - Ken Flerlage: Analytics Architecture, Strategy, & Visualization
You won't be able to pivot three separate fields using Tableau directly, but you could definitely do that in Prep.
Hi, just following up on this to see if we've addressed your question or you have additional questions. Please advise.
I haven't tried Prep yet. I haven't received my license. I did try it in Tableau but it made a bit of a mess.
Thanks for the suggestion. I will download and use the trial period to try this. I will let you know my results.