三維三列 轉一維三列 (10406)

L1:N1 右拉 下拉 {=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF((A$1:G$1=L$1)*(A$2:G$8<>""),ROW($2:$8)/1%+COLUMN(A:G)*10001),ROW(A1)),4),"!R0C00"),),"")