Merging columns from Surveymonkey

**Holliebie** · 03-20-2018, 06:24 PM

Hi, I'd appreciate a bit of help! I have exported survey results from survey monkey. For any multiple choice options, the excel file contains a column for each option, nd each row represents a different survey respondent (see attached pic). In the attached pic, respondents were asked "Which of the following are you attending?" and could choose from four options, private, public, semi-private or other. I want to know how to merge the columns into one column, so it contains the answer for each respondent. The only way I have managed so far is to manually copy and paste all the answers in order, into one column, but is there a quicker way!

Thanks in advance.
Attachment 566581

**sandy666** · 03-20-2018, 06:45 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Don't use Drag&Drop