Change a number and have the row order change

I have a CSV Excel file with quiz questions in it.
The format is Question?;Ans1;Ans2;Ans3;Ans4;CorrectAns;Remediation.
The actual data looks like this:
What color is the sky on a sunny cloudless day?; Blue, Green, Chartreuse, Orange, 1, On most sunny, cloudless days the sky is blue.
What animals swim in the sea?; Fish, Birds, Snakes, Chipmunks, 1, Fish commonly swim in the sea.
Generally speaking, how many tires are on a car? 4 tires, 2 tires, 3 tires, 1 tire, 1, Generally speaking, most cars traveling the nations roads have four tires plus one in the trunk as a spare.
The trouble with this is that all the correct answers have been generated as 1.
How can I change the number in the "CorrectAns" column and have the correct answer's postion change in the spreadsheet. In other words if I change the 1 to a 2, that means that the correct answer must move to the "Ans2" column and what was in the "Ans2 column must more to the "Ans1" column. Is there a way to do this?

Would you be able to upload an example workbook, it will help me help you. Thank you!

I would agree that a small sample file is required because the 3 lines that you provided are not consistent with each other.

How do I attach a spreadsheet file?

sample quiz.xlsx

Sorry, yes, I messed up my initial post. I have attached a sample spreadsheet to illustrate what I'm asking. Thanks for your patience.
Bottom line, the tool that I use for quiz questions creates a preponderance of 1s as the correct answer and I can't have that.
Thanks again.

Hi Ali,
I could not get your example to work for me but I think that it was because of the errant information that I put out initially.
Thank you though.

I attached a spreadsheet with quiz questions in it. Column D is the Question and columns E through H hold the possible answers. Column I shows the correct answer for that particular question. Therefore, if the CorrectAns column is 3 then the correct answer is in the Ans3 column. If the CorrectAns column is 1 then the correct answer is in the Ans1 column. I want to randomize better the numbers in the CorrectAns column. Many times that column up with too many 1's, not enough 2's, etc. HOWEVER, If I change a number in the CorrectAns column then the physical location of the correct answer must change.

For example, if I change cell I2 to a 2, then the correct answer must move from G2 to F2 and an incorrect answer must them move into cell G2. Is there any way to accomplish this?

Yes, certainly, helper columns would be OK. And thanks for moving my earlier post. I realize that it was similar to my original post but I took more care in presenting the data and thought that it merited a new post. Won't make the same mistake again.