I am working with a large data set of survey responses. There are multiple questions that allow respondents to select multiple answers from a list.
I know we can use Pivots, but this is a large number of multi resonse questions will cause the data to be quite large.
Handling data that has a single pivot is easy, but if we have multiple pivots when the data is large could be quite messy.
Is there an easy way to handle this?
I can imagine what you want to say, but still difficult to think about solutions without using sample data.
Could you please provide sample data and clarify the expected results?