Since changing the way survey data exports to reports, is there any advice on how to use this new format to analyze data? We preferred the old format where survey data was displayed with the respondents in rows and the survey questions in columns. That way we could compare by question across respondents, or pull the information into a Word doc mail merge by individual respondents. Now we get an unusable spreadsheet with the questions displayed in rows rather than columns we are at a loss as to how to utilize our survey data. We are looking into moving to another platform for surveys, but really hate to leave CC. Any suggestions on how to manipulate the data since this change are welcome.
... View more