『壹』 Excel問題~兩列數據如何按照一定規律穿插
這族碧樣?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))))