How to merge rows and columns in Google Sheets?

Question

Google Sheets

Can you tell me by chance how to combine the columns?
Photo example. There are 8 columns. AH
The result is first A2-D2, the next line E2-H2.
Then everything is new, A3-D3, but if E3-H3 is empty, then it is skipped.
How to organize it all?

Answer 1

Like this, in each cell the same formula:

=ЕСЛИ(ЕЧЁТН(СТРОКА());
  arrayformula(ДВССЫЛ("R"&((СТРОКА()-2)/2+1)&"C1:R"&((СТРОКА()-2)/2+1)&"C4";0));
  arrayformula(ДВССЫЛ("R"&((СТРОКА()-3)/2+1)&"C5:R"&((СТРОКА()-3)/2+1)&"C8";0))
)

Demo table
If the order is not important, you can make it a filter
=FILTER({A:D;E:H};{A:A;E:E}<>"")