Automated summaries/conversion
 

I have a spreadsheet that is generated by an online suvery. The results are
returned with one row per survey, questions by columns. For
multichoice/single answer questions (Strongly Agree, Agree, Disagree,
Strongly Disagree etc) the sheet puts each of the options as a column heading
and then inserts a "1" in the corresponding column for each survey. Therefore
each survey will only have one "1" under these headings.

Is there a way of converting this into a single column where Agree, Disagree
etc are shown in the same column for each line of the sheet. In other words,
you can read across a row, instead of looking for a "1" and working out which
column it relates to, there is the word Agree (or whatever option they chose)
in a column.

Not sure where to begin with this. Not a Excel expert!

Automated summaries/conversion
 

Use INDEX and MATCH

Assuming your column headers(Strongly Agree, Agree, ...) are in D$1:G$1
and your 1 values in D2:Gxxx

Enter following formula:
=INDEX(D$1:G$1,MATCH(1,D2:G2,0))

HTH
--
AP

"SpencerMC" a écrit dans le message de
news: ...
I have a spreadsheet that is generated by an online suvery. The results are
returned with one row per survey, questions by columns. For
multichoice/single answer questions (Strongly Agree, Agree, Disagree,
Strongly Disagree etc) the sheet puts each of the options as a column
heading
and then inserts a "1" in the corresponding column for each survey.
Therefore
each survey will only have one "1" under these headings.

Is there a way of converting this into a single column where Agree,
Disagree
etc are shown in the same column for each line of the sheet. In other
words,
you can read across a row, instead of looking for a "1" and working out
which
column it relates to, there is the word Agree (or whatever option they
chose)
in a column.

Not sure where to begin with this. Not a Excel expert!