Entering 'Survey Monkey' Survey Responses into RE

Alper, I'm not sure if this is helpful or not ... we also store survey data in RE under an Action, but we use action attributes. This allows us to store the variable responses as a text value and the menu responses as a table value.


Importing as action attributes also requires each field (each attribute) to be its own cell in the same column. You probably do this already: when moving items from a single row to separate lines in a single column, it helps how you sort your spreadsheet beforehand, so that you can just copy one big block of info at a time and paste it to the bottom rows of your spreadsheet.


So if your starting file looks like this:



...you leave Q1 column alone, but sort by Q2, copy the block,




paste to the bottom (blank) portion of the file, then cut column Q2 values in that block...



and paste over column Q1 values in that block. You can then delete the "old" (moved) columns Q2 and Response 2.



Repeat process for Q3/Response3 columns and all subsequent columns.


This process seems involved because of multiple steps, but once you get used to it, it takes literally a few minutes even with a large file of several hundred names. We do this frequently for manually importing Mailchimp data, where RE places multiple email addresses in one row, while Mailchimp requires one email per row as it uses the email address as the unique identifier.


If someone else has a smarter way of doing this, please share! I'm always open to more efficient methods, and maybe there's a formula in excel that I am overlooking.