you can't move columns in the table from side to side since doing so would disrupt the structure from the table. This is what google support and/or help pages say. My problem is that if I create a form in google docs. And I accidentally create a question that I should have created earlier and then I move the question up the form. The column doesn't move in the spreadsheet. So my form spreadsheet looks messed up now. Is there a way to fix this without typing all my questions(89) again. I don't have any results in the sheet yet. So I'm looking for a regenerate sheet option or something like that.
asked Jun 26, 2012 at 10:58 5,823 7 7 gold badges 35 35 silver badges 50 50 bronze badgesThe simplest option is to unlink the form from the spreadsheet it is linked to and then relink it to the same spreadsheet. It will create a new sheet in that spreadsheet, but this time it will be in the good order.
You can then copy the old answers from the old sheet into your new sheet and rearrange them manually.
answered May 30, 2014 at 14:20 181 2 2 silver badges 5 5 bronze badgesIf you follow this answer and the spreadsheet is connected to a form that you manually embedded on another site, do not forgot to grab the new name="entry.xxxxxxxx" and insert it where you had earlier placed the name value.
Commented Dec 8, 2014 at 0:32This works really well. In the latest version of forms it brings over all of the existing data and put the columns in the right order.
Commented Dec 16, 2015 at 15:57Great solution, strikes me as more appropriate than the "accepted" one. I wasn't sure how to link/unlink so here are the steps from googling "Google Forms Link Spreadsheet": - Open a form in Google Forms. - At the top, click RESPONSES. - Below, click More (". ") - Click Select response destination.