Classic quiz writing help needed - I've got rusty.

[sufradley]

I've written a couple of quizzes (inc http://www.sporcle.com/games/sufradley/values_vs_valuables_us) that could do with a reformat to 3 columns. They have two names where the most popular is to be chosen. I tried doing this but got into a pickle when it came to having the third column and having a wrong answer. Could someone please advise?

This is the layout I'm after:
http://www.sporcle.com/games/devotchka/guinness-world-records-comparison

Thank you,
Sui

[Quizmaster91]

You can use the hint column to give option A and the extra column for option B. For the wrong answers, copy the your data from the hint column and put ee in the extra column. The answer column can be used for your text and accepted input. Your data file should look like the file I've attached. Don't forget to give all the columns names or it won't work.

[sufradley]

Thank you, that's exactly what I wanted to do. I'd got so close but failed at the final hurdle. I'll rejig in the morning.
Really appreciate the detail and speed of your response - thank you!