=INDEX(INDIRECT("Sheet1!A:"&CHAR(64+COUNTA(Sheet1!$1:$1)),4),ROUNDUP(ROW(A1)/COUNTA(Sheet1!$1:$1),),MOD(ROW(A1)-1,COUNTA(Sheet1!$1:$1))+1)动态引用将公式变长了。下拉公式
