**Dear all,**

I would like to know how can I convert my 2D data, that is read from excel sheet, into 3D array.

I know, we can do this by using for loops, but its taking alot of memory since my problem is large.

Example to elaborate what exactly I want to do.

*/*Data File*/*

SheetConnection sheet("Question.xlsx");

p1 from SheetRead(sheet,"sheet1!A1:D10");

p2 from SheetRead(sheet,"sheet1!G1:J10");

p3 from SheetRead(sheet,"sheet1!M1:P10");

where number of rows are 10 and columns are 4.

I want to convert these three (p1,p2,p3) 2D arrays into single 3D array.

*/*mod file*/*

range rows=1..10;

range col=1..4;

range Tot=1..3;

int p1rowscol=...;

int p2rowscol=...;

int p3rowscol=...;

int pTotrowscol;

execute{

for (var r in rows){

for(var c in col){

p[1][r][c]=p1[r][c];

p[2][r][c]=p2[r][c];

p[3][r][c]=p3[r][c];

}}}

Though, its giving me few results, but this is not efficient way i guess.

Kindly, give some feedback to do efficiently.

Thankyou in anticipation

regards,

waqas