AA10中输入公式：=offset($A$1,2*row()-2,)AB10中输入公式：=offset($A$2,2*row()-2,)
AA10=INDIRECT("A"&ROW(A1)*2-1)AB10=INDIRECT("A"&ROW(B1)*2)AC10=INDIRECT("B"&ROW(C1)*2-1)AD10=INDIRECT("B"&ROW(D1)*2)下拉填充即可
