Transforming multiple selections (fixed column)
This article is part of The Definitive Guide to Uploading and Preparing Data
Sometimes data is stored in a 'fixed column' format (sometimes known as 'max-multi') where there are a fixed number of variables and the categories contain multiple selection information.
Let's explain by a common example. Consider then you have a categorical array with coded categories (spontaneous brand awareness). Each category is a brand. Each subvariable is the 1st, 2nd, 3rd mention. You want to create a multiple response that just shows the net of respondents who nominated each brand.
In the web app
- Not available