It’s Friday and the brain has stopped functioning. I need to produce a query that looks like the first sheet in the attached Excel Workbook. Sheet 2 contains the query and output of the table.
The report will contain multiple Scenarios and each Scenario will have 2 questions. The columns called distractors are the questions in a drop down list. CorrectAns is the Correct answer, UserAns is what the user choose and the column called ShortUserAns is a ALPHA description of the distractors, distractor_1 is A...Column Correct is an 0 and 1 value and 1 is correct.