SHEET2 A1公式下拉:=IF(MOD(ROW(A1),2),OFFSET(Sheet1!$A$1,(ROW(A1)-1)/2,),"")
=if(mod(row(),2),index(sheet1!a:a,(row()+1)/2),""),下拉填充
=OFFSET(Sheet1!$A$1,ROW(A1)*2-2,)下拉