你好:要两个公式
j2
=OFFSET($A$1,COLUMN(A1)-5+ROW(A1)*5,0,1,1)
n2
=TRIM(MID(OFFSET($A$1,COLUMN(E1)-5+ROW(E1)*5,0,1,1),1,10))