How to transform data array from horizontal to vertical layout

[choletseng]

Convert from such area A:E to H:J

Can someone please help me ? It would be much appreciated. Thanks in advance

[Bo_Ry]

Please try

=LET(z,B2:E99,r,COUNTA(z)/3,c,COLUMNS(z),n,SEQUENCE(r,,0),INDEX(z,INT(n/c)*4+{1,2,3},MOD(n,c)+1))

[choletseng]

@Bo_Ry You are so talented, especially LET worked a charm. That's exactly what I needed , TQVM

[JohnTopley]

Try

=INDEX($B$2:$E$99,INT((ROWS($1:1)-1)/4)*4+COLUMN(A$1),MOD((ROWS($1:1)-1),4)+1)

[choletseng]

Thank you very much for your formula and help, JohnTopley