Hi all,
I'm trying to analyze open-ended responses for survey results.
The survey includes a bunch of demographic, likert, and open ended questions for 10 different classes (class A, B, C, etc... J)
I was able to create pivot tables and connect the datasets with one slicers (by each of the 10 classes).
But I've been having trouble with the responses for 6 open-ended questions.The number of responses vary per question (class A has 67 responses , class D has 0) and there was no limitation on length (responses ranging from yes to 4-5 paragraphs long). Is there a way to slice by class and only have one line gap between the last open-ended response and the next question Q2 which automatically changes based on the # of responses collected?
Thank you
Bookmarks