就是找关系,如图
A7输入
=OFFSET(A$1,CEILING(ROW(1:1)/12,1),)
B7输入
=OFFSET(B$1,CEILING(ROW(1:1)/12,1),CEILING(ROW(1:1)/4,1)-3*CEILING(ROW(1:1)/12,1)+2)
C7输入
=OFFSET(E$1,CEILING(ROW(1:1)/12,1),MOD(ROW(1:1)-1,4))
D7输入
=OFFSET(I$1,CEILING(ROW(1:1)/12,1),)
E7输入
=OFFSET(J$1,CEILING(ROW(1:1)/12,1),)