A. WPS表格，如何快速將一列數據，變為多列
方法1：在sheet2表A1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
b1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
c1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
e1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
f1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
g1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
i1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
j1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
k1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
選中弟一行，公式一直下拉自動填充。
方法2：所有數據復制粘貼到word，分3欄，列印即可。