Summarizing values from multiple columns into one column in Excel
When extracted, data collected using radio buttons sometimes comes out as a TRUE/FALSE column for each option. For example, data from the following question: may look like this in the extract: Data that is spread over multiple columns like this can be hard to analyze (e.g., pivot tables don’t work well with this kind of […]