Btukfyl

so i have this google form for a tournament and people can sign up alone or until group of 6, i have connected the form to my spreadsheet and i want the "sheet1" (which pool the info from the "answers" that contain the sign up people do in my google form.

so i want the spreadsheet to look like this, and i manage to crate a furmola and fill up all the missing info if there is (in different cases which i need to pull the info from answers sheets depend on how many people registered)

image of my spreadsheet

my problem should be really simple compere to the rest but i cant find a way:
each player has 3 rows and up to 7 columns.

C7-8-9 contain the info of the one who registered
but inside them are different address:

C7: =Answers!B2

C8: =Answers!C2

C9: =Answers!D2

now the idea is to copy down the 3 rows
and that they will keep the letter (B,C,D) but will go up by 1 each 3 raw (profile) so C10-11-12 would be =Answers!B3, =Answers!C3 , =Answers!D3 .
but when i copy down its goes up by 3, cuz of the raw,

so when i select those first 3 rows to copy down the formula it goes up by 3
from 2 to 5, then 7, 9 etc etc
i want it to go by 1 only, as a explained before.

cant find a good way to make it cuz if not i need to change the number in a raw each raw manually, and thats goes take millions of hours as i got lots of answers from my form.

how i can bypass that?

Use column A as a "helper column".

In it, on each line, put the row number that applies in the "Answers" sheet. Once you have entered the rows, and the formula are working OK, you can hide the row numbers by changing the font colour to white.

Then use the indirect function to refer to the row number variable.

For example, C10: =Indirect("Answers!B"&A10).

This screenshot shows what I mean, and then below is a sample of the "Answers" sheet.

Main sheet

Answers sheet

UPDATE - Copying helper rows down multiple columns

Lets assume that the helper row values are three sets of 2, three sets of 3, and three sets of 4 (222-333-444). These need to be copied down the helper column for several thousand rows.

The trick is to set the initial value, and make all the other values refer to the initial value. This before "BEFORE" screen shot shows the relationships.

The key point here is the value in the first cell is =2 (note, not 2, but =2). Each of following 11 cells refer to the first cell.

To copy this down as many rows as you may wish, highlight the range of 12 cells, then click and drag the blue range holder down the column. The result is shown in this screenshot.