Simplist approach to convert 1D array to 2D array

[YasserKhalil]

Hello everyone
I have 1D array with 1 million items .. and I need to convert it to 2D array
I know Application.Transpose can do the trick but it will not work with this large arrays
Any ideas?

[HansV]

I fear you'll have to write a loop...

[YasserKhalil]

Thanks a lot, Mr. Hans for reply. I am trying to avoid loops to make the code faster.

[HansV]

I understand, but I don't know how to avoid a loop here.

[YasserKhalil]

I remember something related to using INDEX function for such a purpose..!

[HansV]