将一列内存数组转换成多行多列数组.xls

AB输入拆分行数：2 21结果为内存数组：C列数：12DABCDEFGHIJKLABCDEFEMNOPQRSTUVWXMNOPQRF#G#H#I#J#K#L#M#N#O#PQ定义以下名称：Rdata=A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;XScol_first=ROW(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)+(COLUMN(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)-1)*Sheet1!$E$2Trow_first=COLUMN(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)+(ROW(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)-1)*Sheet1!$E$3U公式：=INDEX(data,CHOOSE(Sheet1!$G$2,row_first,col_first)VW如果为一行内存数组，做法也类似XsnowpeaksnowpeakExcelhomeExcelhome2006-2-222006-2-22先行后列先列后行GHIJKL#STUVWX#=A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X=ROW(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)+(COLUMN(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)-1)*Sheet1!$E$2=COLUMN(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)+(ROW(OFFSET(Sheet1!$A$1,Sheet1!$E$2,Sheet1!$E$3)-1)*Sheet1!$E$3