WPS表格单列转换为多列数据(JS宏方式)

绿色部分是原始数据，黄色部分是生成的数据。

WPS表格里的JS宏代码如下：

/*
	WPS表格单列转换为多列数据
*/
function test() {
	var c = ["B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N"];
	var total_num = 398;   // 记录总数
	var total_colums = 5;  // 多列列数
	var i = 1;
	var ws = Sheets.Item("Sheet1");

	for(y=0;y<total_num/total_colums;y++){
		for(x=0;x<total_colums ;x++,i++){
					var targetCellAddress = c[x]+(y+1);
					var sourceCellAddress = "A"+i;
					ws.Range(targetCellAddress).Value2 = ws.Range(sourceCellAddress).Value2;
					console.log(ws.Range(sourceCellAddress).Value2);
					if(i>=total_num)
						return;
				}
		}
}

文件需要保存为xlsm格式。