Above is a simple representation of my spreadsheet. My survey data was exported in this messy format, with different categories of each question in a different column, even though there was only one response per question. I want to combine them so that all the "Satisfaction" responses are in one column, and same for "Sex". Above is a simple representation of my sprea