非空三區三欄轉置一區三欄 (13543)

K2:M18=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(T(OFFSET($A$1,ROW($1:$8),{0,3,6}))<>"",ROW($2:$9)/1%+{1,4,7}*10001),ROW(A1)),4)+COLUMN(A1)-1,"!R0C00"),),"")