Merge multiple matrix questions into one for ongoing survey

Question

We have an ongoing survey that has had many changes over the years. There are 2 matrix tables and both have the majority of their statements now hidden from respondents, but we keep the old statements in the survey to retain the historical data. To improve survey design we want to combine the statements that are still shown to respondents so they are in one matrix table. I am wondering what the most efficient way to migrate these statements would be. We need to add the statements and also move the historical data into the new field because it will be trended on the dashboard. What I am thinking right now: add the statements from 1 table into the other as new fields and then manually move the data from those statements to the new fields. I would filter the data by scale point -> select all responses -> add that scale point into the new field -> repeat for each scale point (9 point scale) -> delete the old statement from the matrixNot too difficult but manual and annoying. Are there any simpler or more efficient ways to do this?

chasemcl · Accepted Answer

Figured it out very anyone who interested https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/add-new-fields/combining-fields/

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded