示例：一维表变二维表

结果：

代码：

function test(){

var arr=Range("a2:c"+Cells(9999,1).End(xlUp).Row).Value();

var num=1;

Range("a1","c1").Copy(Range("e1:g1"))

for(var ar of arr){

var newarr=String(ar[2]).split("、").map(v=>[ar[0],ar[1],v]);

for(var a of newarr){

Range("e1:g1").Offset(num++).Value2=a;

}

}}

function test(){ var arr=Range("a2:c"+Cells(9999,1).End(xlUp).Row).Value(); var num=1; Range("a1","c1").Copy(Range("e1:g1")) for(var ar of arr){ var newarr=String(ar[2]).split("、").map(v=>[ar[0],ar[1],v]); for(var a of newarr){ Range("e1:g1").Offset(num++).Value2=a; } }}