Here is a formula solution for your reference only
In A11 array ("Ctrl+Shift+Enter") formula copied right to D11, and all copied down :
=IFERROR(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,TRANSPOSE($A$3:$A$7)&"</b><b>"&TRANSPOSE($B$3:$B$7)&"</b><b>"&TRANSPOSE($C$3:$C$7)&"</b><b>"&TRANSPOSE($D$3:$I$7))&"</b></a>","//b["&(ROW($A1)*4+COLUMN(A$1))-4&"]"),"")
I think it will be easier to solve it by
PQ in the "unpivot way", of which I would like to ask for
@GraH - Guido ,
@AlanSidman or
@p45cal to give you a help.