Geek Answers Handbook

Copy columns to spreadsheet from google docs form

You cannot move columns in a table from side to side, as this will violate the structure of the table. This is indicated by the Google support and / or help pages.

My problem is if I create a form in Google Docs. And I accidentally create a question that I had to create earlier, and then move the question to the form. The column does not move in the spreadsheet.

So my spreadsheet now looks confusing. Is there any way to fix this without typing all my questions (89) again. I have no results on the sheet yet. Therefore, I am looking for a variant of a regenerated sheet or something like that.

+4
source share
4 answers

If you move questions in a form, the order in which questions and answers appear in the so-called forms answer sheet remains the same as the one in which the form questions were asked.

However, you can rearrange the columns of questions_and_answers in the forms answer sheet so that it matches the order in which the questions appear on the form (yes, there will be a warning against this, but I did it safely despite the warning) ... see my next blog post to illustrate ... http://yogi--anand-consulting.blogspot.com/2011/11/yogimake-column-headers-and-answers_27.html

+3
source

The easiest option is to cancel the form from the table to which it is attached, and then move it to the same table. He will create a new sheet in this table, but this time he will be in good condition.

Then you can copy the old answers from the old sheet to the new sheet and manually change them.

+13
source

Solution 1

Unless you have a large number of checkboxes, etc., but just empty short answers, how about:

  • Make a copy (to check)
  • Delete the form.
  • Move columns
  • Create a form. (By default, short blank answers to your questions will be asked.)

Solution 2

  • Make a new sheet
  • Use the array form to copy the results from the first sheet, placing them where you want.
  • hide the first sheet.
+2
source

If you have not yet collected the answers, the easiest solution would be to copy the report.

Once you have the questions in the correct order, click File>Make a Copy .

The answer table for this new report will be in the order of your questions.

-1
source

More articles:


All Articles