Basically, I have received data from a survey.

Every other column is the Question on the survey, then the next column is the Answer. (i.e., |Q1|A1|Q2|A2|Qn|An|). Each row is a new respondent's set of answers. Sixty-seven questions, 140 respondents.

I'd like column A to be a stack of all questions, and B to be all responses. (That is, rows A1-A140 is Q1, B1-B140 are all the answers to Q2, A141-A280 is Q2, B141-B280 a list of all the answers, and so on).

Seems easy enough, but...?

Thanks