How to use CONCATENATE and INDEX together?

Question

Google Sheets

Good afternoon! There is a form from which data goes to several "Class" columns, then a column is created with general data from the remaining columns, using "CONCATENATE".
But when filling out the form, a new row is created and the data disappears from the general column. Therefore, I created another sheet where I display everything that I need. Here I use INDEX and CONCATENATE, but it turns out to be displayed only this way, but it is necessary that the data go to each cell, except for D1: G1. Tell me please)

Answer 1

Maybe something like this will work for you

=ARRAYFORMULA(
  REGEXREPLACE(
    TRANSPOSE(QUERY(TRANSPOSE(D1:G&"|"),,COLUMNS(D1:G))),
    "(\|\s*)+",
    ", " )
)

Specifically for your table, you can

={"В строку";ARRAYFORMULA(REGEXREPLACE(
  REGEXREPLACE(
    TRIM(TRANSPOSE(QUERY(TRANSPOSE(D2:G&"|");;COLUMNS(D2:G))));
    "(\|\s*)+";
    ", " );
  "(^,\s*)|(,\s*$)";
  ""
))}

See solution https://docs.google.com/spreadsheets/d/11YHMGv80tk...
See example https://docs.google.com/spreadsheets/d/1a1MZ_kik2h...
Formula description https://oshliaer .github.io/qna?target=post/google-...

Answer 2

There is a way to chain multiple columns into 1 line by line: =ARRAYFORMULA({C1:C10}&{D1:D10}&{E1:E10}&{F1:F10}&{G1:G10})