How to transfer data from google forms in google sheets?

I created a form and linked it to a table, the table has a sheet with answers on the form, I using the formula (='the Answers to the form (1)'!C1) tried to transfer the data from the worksheet with the answers on another sheet, then I simply pulled this formula across the table, but when the answer sheet appears as a new row, all the formulas change cell values below 1, i.e. if (='the Answers to the form (1)'!C1), it became (='the Answers to the form (1)'!C2). How to make these values did not change without the use of fixation of cells using "$" or how you can lock in 1000 cells at once with "$"?
April 4th 20 at 00:28
1 answer
April 4th 20 at 00:30
This should help. On-line in the indirect() all the tricks avtosalony do not apply.
=arrayformula(indirect("'Answers to the form (1)'!c1:c)"))

Find more questions by tags Google SheetsGoogle Forms