同名称非空白 提取 (9953)

 

 B9:N10{=IFERROR(INDIRECT(TEXT(SMALL(IF(($B$2:$N$6<>"")*($A$2:$A$6=$A9),ROW($2:$6)/1%+COLUMN($B:$N)),COLUMN(A1)),"!R0C00"),),"")