We need to extract the results of one of our surveys. Each response should be on a row with answers to questions as columns. You can easily extract in this format for Google Forms and Microsoft Forms which actually makes more sense since you will have a lot of questions and a lot of responses.
Our issue is if we get for example 5000 responses and we have 10 questions, the number of rows when you want to extract the raw survey result data gets extremely large. Because of this problem, we now need to manually change the rows limit when extracting or extract result per question and manually rebuild them on a spreadsheet to get the expected output.
Expected output:
ServiceNow output:
Number of rows if you have 10 questions and 5000 survey respondents:
10 rows per respondent * 5000 respondents = 50,000 rows (THIS IS THE PROBLEM)
Take note that this is just for a 10 question survey.
We have something like this but for the numeric value of the responses since the Multilevel Pivot report in ServiceNow does not support the String values.
Report setup is like this:
The result is something like this:
