Automated summaries/conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top