How to fix the situation: when filling out the form and pulling up the results in the formula, the values ​​\u200b\u200bmove one line down?

Question

Google Sheets

Friends, please help.
How to fix the situation: when filling out a google form and pulling the results into a table in the formula, the values ​​\u200b\u200bmove down one line (automatically move down). How can this be fixed?

Answer 1

You need to use ARRAYFORMULAfor array address calculation.
=ARRAYFORMULA('Ответы на форму (4)'!B2:B * 13)