If you add Product to your rows and Metric Value, and then add Country to text, it should give you the correct result. Or are you facing challenges with this approach?
I'm not sure what you mean? What are you saying makes sense in desktop, but I need to create this structure in tableau prep then join it to other files downstream. I'm new to prep so I maybe missing something, seems like you can unpivot data but not the other way around.
Ah, I understand. As far as I know, there is no way to unpivot the data with prep, but perhaps one of the members on the forums have achieved something similar?