这样?c1=IF(ROW(A1)>COUNTA(A:B),"",IF(MOD(ROW(),3)=0,INDEX(B:B,ROUNDUP(ROW(C1)/3,0)),INDEX(A:A,(ROUNDUP(ROW(C1)/3,0)-1)*2+(MOD(ROW(C1)-1,3)+1))))