Create four arrays from one array

Hello everybody
I have some values in C3:V3 (20 values). I need to create an array (five arrays) of the main array C3:V3 in this way

Temp1 equals to values in C3-G3-K3-O3-S3
Temp2 equals to values in D3-H3-L3-P3-T3
Temp3 equals to values in E3-I3-M3-Q3-U3
Temp4 equals to values in F3-J3-N3-R3-V3

Thanks advanced for help

I have seen you use arrays in other projects, so I wonder exactly what you are stuck on here. I also wonder if your intention is to store the result in 4 different 1D arrays, or do you want 1 2D array, or do you want an array of arrays.

I would probably use a 2D array, with a loop with three counters, one counter counts the first dimension of the array, one counter for the second dimension, and a third counter to keep track of where I am at in the row:

Please Login or Register  to view this content.

or something like that.

Thank you very much MrShorty
I tested that and it is ok

Please Login or Register  to view this content.

But I need to store the results in four different separated arrays

@Mr. Kenneth
Thanks a lot for this awesome code. That's exactly what I was searching for
Best Regards

I need more little help Mr. Kenneth
I need to merge the new arrays (the output of your code)
Create new array to hold the new output as following

1- temp1 to be merged with temp2
2- temp1 to be merged with temp3
3- temp1 to be merged with temp4

4- temp2 to be merged with temp3
5-temp2 to be merged with temp4

6-temp3 to be merged with temp4

As for these six results to be in one array
If possible I need to duplicate each item from the six .. I mean for example: after merging "temp1 to be merged with temp2" to duplicate this again
so I would imagine to have 12 items >> each item and the next are the same

Hope it is clear

I know it is may be confusing so I put my imagination in this picture
11.png

And this is the final output I desired
22.png

I found this udf that merges two arrays

Please Login or Register  to view this content.

But it takes value from one array and value from the other array and so on
And my need to have all the values of the first array the all the values in the second array

I have tried and edited the udf to suit my case

Please Login or Register  to view this content.

Can you help me to do the merge for arrays and the whole results to be put in one final array?

This is a sample workbook with the final code (It is Kenneth's code)
We can start from this post

After merging the arrays in this way

Please Login or Register  to view this content.

How can I populate it to range("N3")?

This is my try. Please correct me if I am in wrong way

Please Login or Register  to view this content.

But of course I missed to duplicate each array as I illustrated earlier
How can it be easily done?

Is there an easier way to do looping for these lines

Please Login or Register  to view this content.

Do you mean dealing with reply in post#15? My issue now is different
I need to simplify the code in post # 15 ...