轉換數據 (8970)

A13:G20{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($N$13:$T$20<>"",COLUMN($N:$T)*10001+ROW($13:$20)/1%),ROW(A1)*7-7+COLUMN(A1)),4),"!R0C00"),),"")

另解 (數據連續 無跳格空白)=OFFSET($N$13,MOD(COLUMN(A1)+ROW(A1)*7-8,8),INT((COLUMN(A1)+ROW(A1)*7-8)/8))&""