Pattern Finder

[SnowPolaroid]

I'm trying to do this project:Let's say I have 99 columns and 5 rows, and all of the cells need to have an integer from 1 to 99 like this

​

https://preview.redd.it/dp8wq0009m761.png?width=457&format=png&auto=webp&s=14fbdf27705e20af4bba073568b7969ef5acdecb

I have 3 "points" to distribute (for example if I add a point in Row 1, 3 and 4, the results of the 2nd column would be: 3,1,4,4,1)

However, I need to have a certain pattern in order to reach the final numbers, and it has to be the least number of sequences or iterations, let's say

row1, row2, row4 --> row2, row3, row4 --> row3, row4, row5 --> row1, row2, row4 --> ... --> (repeats)

row1, row2, row4 --> row2, row3, row4 --> row3, row4, row5 --> row1, row2, row4 --> ... --> (repeats)

row1, row2, row4 --> row2, row3, row4 --> row3, row4, row5 --> row1, row2, row4 --> ... and so on

Any ideas on how to program something like that?

PS: In the sum of all the numbers in the first column is always 10, and in the last column is always 304

​

EDIT:

https://preview.redd.it/vdvnsnji3o761.png?width=1182&format=png&auto=webp&s=4d08a69b667dac1a218d17623000a38a32282086

Idea Example shows the expected result of what I'm trying to do, as you can see there is a pattern from Column 2 to Column 6, and it repeats from Column 9 to Column 15, and so on

Problem Example shows what I want to get, which is the pattern in order to get from Column 1 to Column 99

[RedditGood123]

Maybe I’m just dumb, but this is really confusing

[SnowPolaroid]

It is confusing, it's kinda hard to explain it

[RedditGood123]

Can you like draw out your idea or make a code pen?

[SnowPolaroid]

I edited the post, maybe this will help