Sorry, apologies I should have made it clearer.

The questionnaire is completed using a google docs form...with answers like Agree, Disagree etc. I need to find a way to code these verbal answers into numbers (1-5), while at the same time making sure that each question (column) is coded either 1-5 or for the reverse code 5-1.

Again, any advice is most welcome!