So you want to count number of values that are separated by ',' in field 2 ?
yes you need to split the data out into individual fields and then pivot the data to get the data set into a tall narrow data set
it is easiest to use tableau Prep to clean the data - that is what it was designed to do
the command is split and the custom option allows you to split out all the values at once - then add a pivot step and remove the nulls
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.
If you need to do it in Desktop rather than Prep the best way I can think of is to Regex it and split it out by each answer. Create a new column for each possible response and do a regex search for that response.