2 Replies Latest reply on Jun 28, 2019 12:12 PM by Mavis Liu

    Pivoting Multiselect Survey Responses

    Dan Cole

      I have a survey with tons of "check all that apply" questions, as well as questions with open-ended responses which I've since read through and categorized.


      What would be the best way to pivot on these without turning my dataset into mostly NULL responses and millions of records? There are more than a dozen of these types of questions, many with 20 different options, and 200 survey responses.


      For example, one of the questions we asked was open-ended and for respondents to provide lists of software tools they'd recommend and ones they would NOT recommend:



      Any recommendations or best practices would be recommended!