1 of 1 people found this helpful
Currently you can split a data field into multiple columns based on a delimiter, and you can pivot columns into rows. However, you cannot currently pivot calculated fields (which is what you get when you split a field). So for now I think it would be easier to transform the data outside of Tableau. Possibly even with something like a custom SQL query.
I recommend voting on https://community.tableau.com/ideas/4477
Hope this helps
Really appreciate the thoughtful response. Thanks!