The newer survey response export is a mess! The questions and responses should be column headings, not additional data in the respondent's row. C'mon! This is basic spreadsheet stuff. Get your constant and variable data straightened out. Now I get a separate records (rows) for each time a respondent answers each question - not helpful, especially when I write follow-up questions. I need to scroll through all the records pertaining to question one and hope I find that person's corresponding follow-up response among the rows of question two records. How did this ever get past your test phase?
... View more