=MOD(ROW(A1),2)=1
=IF(MOD(ROW(A1),2)=1,内容,'')
=ROUND(ROW(A1)/2,0)
=INDEX(汇总原表!A:A,ROUND(ROW(A1)/2,0)+2)
=IF(MOD(ROW(A1),2)=1,INDEX(汇总原表!A:A,ROUND(ROW(A1)/2,0)+2),'')
=IF(MOD(ROW(A1),2)=1,INDEX(汇总原表!G:G,ROUND(ROW(A1)/2,0)+2),'')
=IF(MOD(ROW(A1),2)=1,'',INDEX(汇总原表!G:G,ROUND(ROW(A1)/2,0)+2))
=IF(MOD(ROW(A1),2)=1,INDEX(汇总原表!E:E,ROUND(ROW(A1)/2,0)+2),INDEX(汇总原表!F:F,ROUND(ROW(A1)/2,0)+2))
·END·
联系客服