EXCEL问题,不规则多列如何变成一列答:=OFFSET(A$1,MAX(IF(SMALL(--IF(A$1:G$20<>"",COLUMN(A1:G1)&TEXT(ROW($1:$20),"000"),9^9),ROW(A1))=--(COLUMN(A1:G1)&TEXT(ROW($1:$20),"000")),ROW($1:$20)))-1,MAX(IF(SMALL(--IF(A$1:G$20<>"",COLUMN(A1:G1)&TEXT(ROW($1:$20),"000"),9^9)...