If you haven't found Steve Wexler - Zen Master and the go-to for survey analysis - suggest you see the link below Steve Wexler | Tableau Software
It will take you through structuring your data -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Appreciate the link, he seems very insightful. Read through his guides but am still having a bit of trouble so am leaving the question open. I'd ideally like to solve this within Tableau itself vs. modifying my data structures, as I'm still finding it difficult to deal with structuring multiple selection picklist questions.
once your data is structured properly the solution is straight forward - in the link Steve uses prep = you can do the same in tableau and cleaning you data prior to loading