I think adjusting your data in Tableau Prep will make your analysis easier.
Please see these excellent posts from Steve Wexler using on working with Survey Data:
In Tableau desktop, I pivoted your columns into one:
Then very roughly parsed out a question number:
MID([Pivot Field Names],2,3)
This can be done more precisely with Regex.
Then I placed the fields as shown below and filtered out the Nulls and the "-".
Please see workbook v10.3 attached in the Forum Thread:
285996survey.twbx 35.3 KB
Please be mindful that if/when you reply to forum posts via email that your contact details will be included...
Great team by the way!
I think that Tableau Prep is currently free through June 2020 with a Desktop license.
You can check with your Admin or Rep for the license key.
But if that's not available for you, it will depend on the capabilities for connecting to
the turnkey surveyor web connector. I do not have experience with it. Two things
to check once you've connected to the datasource:
1. When you select your different fields on the Datasource Tab and click on the down arrow,
do you get the option for "Pivot"?
2. Alternatively, check if it allows for a Custom SQL connection:
If neither works for you, we can explore other options.
Nonetheless, the Wexler links give examples of the general data table format
we are seeking to emulate, which will make it easier to pull in and analyze in Tableau.