In order to analyze ZIP code data which respondents provided (984 total), I had to first export the zip codes, standardize to ensure 5 digits ("0" added to less than 5 digit entries), and then use a vlookup formula to bucket them into two new buckets which we want to analyze by (NY Metro v Non-NY Metro) - see sample data below.
!
However, when I go to import the .csv file back into Qualtrics I'm unable to as it says 'No columns have been selected to important' (see below). How can I upload this data so that I'm then able to analyze by these two new buckets?
!
Thanks in advance.
Best answer by KendraR
View original