Iterate over two index variables to reorder an array

Hi,

I have to reorder my array and paste it to a sheet. I am trying to do this with a for loop that iterates over two index variables.

Please Login or Register  to view this content.

But I dont get it to work. I have attached example of my array. That better explains what I am trying to accomplish.

This works, but far from elegant and not very efficient.

I would like to reorder arrays in VBA and than paste to sheet.

Please Login or Register  to view this content.

beutiful, more efficient. thanks