整理数据 (10248)

N2:P2 下拉 {=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(($A$1:$I$1=$A$1)*($A$2:$I$99<>""),ROW($2:$99)/1%+COLUMN($A:$I)*10001),ROW(A1))+COLUMN(A1)-1,4),"!R0C00"),),"")