pattern/repeat

Beloved experts in the house, I've a data list of numbers in in 4 column, so I discovered that there move with a unique patterns and formation. So the question is, how can I search for combinations of patterns in the 4 column at once.

I have been puling my hair out trying to figure this out and have recently found this thread: How to search for random patterns within a column answering a very similar question to what I'm asking below, but this is looking for strings of 5 characters in a column of random letters and numbers...

I have to repeat this process for many names like following output. Is there any way to do automatically by click one #button(VBA or any) without dragging option. Ex: if we enter names in any data form or in certain cells then it should get repeat itself(automatically) based on already filled A...

So I have a question (which I hope someone can give a quick answer). What I am trying to achieve is as follows: 1 2 2 3 3 3 4 4 4 4 So essentially have the number pattern/repeat based on the number itself and also increase. I need this to go all the way to at least number 36. Anyone has a...