比如图1是sheet1图2是sheet2 sheet2
A2输入
=OFFSET(Sheet1!$B$1,(ROW()-2)*6,0)
B2
=OFFSET(Sheet1!$B$1,(ROW()-2)*6+1,0)
C2
=OFFSET(Sheet1!$B$1,(ROW()-2)*6+2,0)
D2
=OFFSET(Sheet1!$B$1,(ROW()-2)*6+3,0)
E2
=OFFSET(Sheet1!$B$1,(ROW()-2)*6+4,0)
下拉复制公式
用宏来处理吧
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024