I have an odd ask and figured I'd reach out to see if anyone had a solution. I have a project that I'm exporting the data out to SPSS and then saving it as an Excel file as labels. I've created variables and ordered it so my client can just copy the rows of data and paste into and Excel spreadsheet they are using for a qualitative recruitment. My stuck point is there are two questions that are multiple response (26 response choices) and they wanted to have all the responses in one cell of their spreadsheet. I created a list of the selected responses and was able to export those lists so that the responses are all in the first few columns of data, but I can't seem to see a way to get them into one cell.
So, would there be any way to export, or in the program convert them, into a text field? Similar to being able use display list labels to show a list on the screen but actually saving that into a text field that could be exported. Any solutions?