I've attached a spreadsheet that contains the output from a test program. Some of the questions received points (example: 0 out of 2 points), which means they were correct.
Without changing the format of the current spreadsheet. I would like to be able to run an excel macro and have another spreadsheet populated with a column for the question (note: do not use question numbers), a column for the correct answer, and a column for the incorrect answers.
I would like to be able to add more questions to the spreadsheet without breaking the macro.
It doesn't necessarily need to be an excel macro. So, I've also attached a plaintext example. The program must be able to process the plaintext example and create an output file, or process the spreadsheet with a macro.