1 of 1 people found this helpful
Quick question, if this exercise is for one time or for long term. If this is for one time then you can follow the below approach else you should use some database ETL tool for such exercise.
Connect your file in tableau and apply custom split in all the three columns which you've mentioned. Follow the link for more information.
Copy the entire data and paste it an excel workbook.
Delete the original fields C,D,E and keep only split fields. Save the data
Now, connect the new split data in tableau and select all the split field and apply pivot on them. Follow the link for more information.
In that way you can get the desired data set. Let us know if this help.
Thank you for your help!! it worked nice for the 1st time, but now that i need to refresh the whole beast (and will need to refresh on a weekly basis), this approach becomes cumbersome...
Is there any way to do it sustainably?