“… there will be »segments«”: cutting up a sequence into smaller chunks

Hello everyone,

Beginning in A1, I have a row (which I will call R1).
This row can be of varying size (79, 25, 43, 91, etc.) but is, at the most, 100 cells long.
The cells of R1 can contain any written element (numbers, letters, symbols, words, etc. but no formulas!).

Now, I wish to cut up R1 into smaller segments. For this, I want to use a second row (R2).
Beginning in A2, this row (R2) stipulates the number and size of the segments.
These segment-numbers are never larger than 20.
As an example, let’s say R2 is: 8, 3, 6, 6, 11, 19, etc.
The resultant segments would then be displayed from A4 onwards.

I would imagine it to somehow look like this:

[A1] X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X, X .............. (this is R1)
[A2] 8, 3, 6, 6, 11, 19, etc. (this R2)
[A3]
[A4] X, X, X, X, X, X, X, X (these are the segments)
[A5] X, X, X
[A6] X, X, X, X, X, X
[A7] X, X, X, X, X, X
[A8] X, X, X, X, X, X, X, X, X, X, X
Etc.


To recapitulate:
R1 is a long row of diverse data which I have from somewhere else and which I need to cut up. Ergo, the actual content of R1 (that is, the elements in each cell as well as the actual amount of cells) will always change (but will contain a maximum of 100 cells).
The numbers of R2 are also inputted by me and will also always change. As a rule, they are between 1 and 20; (i.e. there are no negative values in R2).

I hope this makes sense.

Two final points:
1. If the numbers of R2 are not enough to partition R1, R2 will start over again (and again) until R1 is fully divided into segments.

2. If the numbers of R2 are too many to partition R1, the function will stop automatically at the point where all elements of R1 have been divided. This would mean that R2 is not fully used.


I have a feeling this might be difficult and better done with Macros but I don’t know enough to assess this.
I would appreciate any pointers or advice.

Thank you in advance.

Hello dredwolf and daddylonglegs

The functions work very well.
The amount of manual work you have saved me is enormous.
Thank you both very, very much for your help.

I have quite a few questions as I am trying to learn but I will limit myself to just one if you would:
Can I extend the maximum number of cells for R1 to 200 or 300 (leaving everything else as it is)?
Dredwolf's function seems to go beyond 100 cells but would not continue to partition R1 if R2 required repeating (see your posts above).
Daddylongleg's function does indeed repeat R2 until all of R1 is divided but stops at 100 cells (as I, admittedly, asked for).
Is it possible to combine the two?

Thank you both again

Thanks daddylonglegs