转换为一列数据 (12184)

F2{=INDEX($1:$1,SMALL(IF(ROW($1:$9)<=MMULT(COLUMN(A:H)^0,N(B$2:D$9>0)),{2,3,4},99),ROW(A1)))&""

G2{=IFERROR(OFFSET(A$1,SMALL(IF((B$1:D$1=F2)*(B$2:D$9<>""),ROW($1:$8)),COUNTIF(F$2:F2,F2)),MATCH(F2,B$1:D$1,))&"","")