I have attached an excel 2007 spreadsheet (Sample) that contains a small sample of a larger output file.
Another sheet is included with the expected output.
These data represent 3 subjects(Column A) who answered 5 questions, each with 10 possible answers numbered 0-9, represented by the 5 consecutive 0-9 columns in Row 1.
Each subject chose one of the 10 answers for each of the 5 questions. The answer they chose is marked in that subject's row under the appropriate column with a 1. I need code that would transform each answer into the
actual numerical choice shown in the same column in Row 1.
This number should be displayed in the appropriate Subject's Row under the column names for each question -Q1, Q2, Q3, Q4, Q5 (See Output Sheet). Thanks