Survey Response Scales in Different Columns?! 3 Excel Workarounds

Are you running into this weird export issue, where each survey response option is separated into its own column?

This “tons of separate columns” format doesn’t play well with formulas, pivot tables, or charts.

In this tutorial, you’ll learn 3 workarounds:

https://www.youtube.com/watch?v=7VMlRPyra1g

What’s Inside

• 0:00 The challenge: Survey response options are exported into tons of separate columns. ​
• 1:10 Solution 1: Manually type, copy/paste, or use CTRL +F+replace
• 1:55 Solution 2: Create a new column and =sum them
• 3:10 Solution 3: Just use a pivot table

Download the Spreadsheet

And try it yourself. It’s here.