how can I repeat values in cells multiple times?

[alisam]

hello Gurus
my question is as follows:
I have a column with filled consecutive numbers, from 1 to 2800.
I need to repeat these numbers multiple times
in attachment the before and after.
thank you and regards

Alisa

P.S. I am sure it is not difficult...please just be patient

[KOKOSEK]

Hmm, you have 365, so we can try something like this.
There is no before, it is just after
Put into starting cell of "after":

Please Login or Register  to view this content.

As xMaxNumber put 2800 (instead of 50 above) and as xRepeats = how many times you want to repeat each number (instead of 3 above).

[shreksbro]

I suspect most unsophisticated users (like myself) would do this:

A1: 1
A2: 1
A3: 1
A4: =A1+1

Then just copy cell A4 and paste it all the way down to row 8400 or so. Job done.

After that you might want to copy the whole column and "paste values" back over itself to lock all the numbers in, otherwise the formulae will mess up if you sort the sheet by a different column.

[Glenn Kennedy]

or:

=TEXTSPLIT(CONCAT(REPT(SEQUENCE(20)&",",5)),,",",1)

red the sequence of numbers to repeat. Green, the number of repetitions.

[alisam]

hmm, it does not do anything.....

[alisam]

works like a charm, thanks

[Glenn Kennedy]

Not sure who you are talking to....

but...


You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.