1 of 1 people found this helpful
Hi Mary, welcome to Tableau and the community! Is the attached workbook something like what you're looking for? If so, here's what's done:
1. Pivot all columns that may hold any responses. In other words, any 'county' columns:
2. Identify them as 'Question' and 'Answer'
3. Since we've pivoted data, there are now multiple rows per ID. To avoid double counting these, we can create a calculated field.
[Number of Respondents] = COUNTD([ID number])
4. Finally, not all rows will hold a valid response, as some may have not been provided by the respondent. To exclude the empty rows, we can add a filter for 'Answer' and exclude nulls: