Excel问题~两列数据如何按照一定规律穿插?

2025-04-06 14:26:20
推荐回答(1个)
回答1:

 这样?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))))