A summary of two fool-proof methods to pivot split columns in Tableau.

While I’m doing my personal data analysis project, I came across a problem which is that Tableau doesn’t allow me to do pivot on split columns. I read through lots of answers on Tableau Community Forums and tried two methods that are, personally, easy to understand and implement. I didn’t see any posts that summarize these two methods together (or maybe this is just a dump question that only me as a beginner will struggle😅). Anyway, I think writing this is fun and hopefully will be beneficial to someone else who have the same issue in the future.

If you…

Rui Zhang

Passionate about telling stories from data.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store