Parse Data from one dimensional array into a 2 dimensional array.

OK, Obviously I know the answer to the question, but I would like to see what method other people would use to get the same result. So if you want to answer purely to help, I don't need it as I already have the code to do what I want, I just think that it can be done better and would be interested as to the different angles each person would choose to attack something like this.

OK, the problem, a simple issue of parsing data.

I have a one dimensional array in column A with 56 cells of data. The data needs to be broken into a two dimensional array, 14 cells of data over 4 columns alternatively. ie, 1 - 14 in column D, 29 - 42 in column E, 15 - 28 in column F, 43 - 56 in column G, and have this repeated by 5 columns.

I have attached a file showing the out come of the array.

Cheers Dave

Hey Pete. No, those number are just for reference. Just the yellow filled cells are part of this problem, but there is an empty column every 4th column, hence the 5 column repeat.

Cheers Dave

Hey Pete, Unfortunately it is an array in memory, so that can't be used. And to answer the last question, I don't need to see the reference numbers.

Thanks for answer though, rep for you.

Dave

No one else? Hmmm