Thanks for your hepl, but I need that the function do the breaks
automatically for every change in the first column (they are variables) cuz
the number of rows is too high
" wrote:

Hello,

I think you need to define 5 calls to my function:

1. Select 4 cells in one row and enter =copy_row_wise(B1:C2) as array
formula.
2. Select 4 cells in two columns and two rows and enter
=copy_row_wise(B3:C4) as array formula.
3. Select 8 cells in four columns and two rows and enter
=copy_row_wise(B5:C8) as array formula.
4. Select 4 cells in one column and enter =copy_row_wise(B9:C10) as
array formula.
5. Select 2 cells in one column and enter =copy_row_wise(B11:C11) as
array formula.

HTH,
Bernd