Merging responses from same question, but different blocks

Download the data and reupload it back so that all answers from these questions are combined in one column. At least this is the only option i can think of..

Thank you! Could you explain the download/upload process a little more? Would this create duplicate responses?

I thought I would be able to create a new variable using "Create or Clean Variable," but I haven't found a way to do this yet. I feel like there's something there, but no luck so far.

Thank you so much for taking the time to explain this! I have figured out a way to combine the questions to create one variable:

* Under the Analysis tab in Data & Analysis, you would select "Create or Clean Variable" on the left hand side of the page (where all your variables are listed)
* Using the Logic option to create a new variable, you give it a name at the top and start selecting the variable you want to combine into one...so for example, if I asked all my 6 blocks how long they worked for "XYZ," I would maybe call the new variable "Career Length" and find that question in all of my blocks.
* So I pick the questions I want to combine and then for each question, I select "equals" and then select the same response category for each. I would repeat this step by clicking the small plus button right next to "Select Value" so each of the paths where I asked this question are added and they all are equal to the same response category.
* You also want to make sure you change "If ALL of the following are true" to "If ANY of the following are true"...this choice will appear after you choose to add another condition
* To add a new response category, click on the small plus sign to the far right of the window to add a new condition set...it will bring up another box below your first condition set and it will say, "Otherwise if..." and you will then repeat the same process as above. Remember to change "If ALL of the following are true" to "if ANY of the following are true"
* repeat this process until all of your response categories for your new variable are represented
* Below each of the new conditions you made, where is says, "Set Value To..." I chose "Text" from the drop down menu and type in what I want that new response category to be called. So for my "Career Length" example, I would name my response categories as they appear in the original question..."Less than 1 year," "1-2 years," 3-5 years," etc...

This is so hard to explain in words (for me, at least) so I hope this is clear! It worked like a charm and I was able to combine all of my like variables into one that I am now able to use for analysis.

I hope this helps in your future endeavors!

@Simonmd I’m also interested in combining responses to the same question asked to different groups. Please could you share the guidance you were given, I can’t see a link?

Thank you