B1单元格写入公式=OFFSET($A$1,ROW(A1)*5+COLUMN(A1)-6,)或=INDEX($A:$A,COLUMN(A1)+ROW(A1)*5-5)再或=INDIRECT("A"&COLUMN(A1)+ROW(A1)*5-5)右拉再下拉复制公式
b1=index($a:$a,column(a1+row()*5-5),下、右拉
