I'm developing a survey study with multiple conditions. I have 6 blocks for each of the different conditions, and I apply a randomizer in the survey flow to randomly assign a condition to each participant, and capture the assigned condition using an embedded data field. However, when I export the data, each question in each block is assigned a separate column. Is there any way that I can merge questions across blocks so they output in the same column? I have labeled each question in the same way across each block (see below example, current output, and desired output). I could do post export processing, but I wanted to check that there was not an easy way to achieve this result without post export processing.
Example survey layout:
Block 1
Q1
Q2
Q3
Block 2
Q1
Q2
Q3
Block 3
Q1
Q2
Q3
Current Output
Q1,Q2,Q3,Q1,Q2,Q3,Q1,Q2,Q3
1, 0, 1
-----------0, 1, 0
--------------------1, 1, 1
Desired output:
Q1,Q2,Q3
1, 0, 1
0, 1, 0
1, 1, 1
Best answer by Kate
View original