A
A
Alina Shah2022-04-05 18:57:59
Google Sheets
Alina Shah, 2022-04-05 18:57:59

How to automatically duplicate numbers, with a changing number of digits?

https://docs.google.com/spreadsheets/d/1GP-U3daCDn...

There is a product of numbers transported line by line and you need to automatically duplicate them down by 100 lines (+/- loop).
The task is that there can be either 4 or 5 or 6 digits, so it is not relevant to do it manually each time.

For example, now the product in cell AF7: 35568, it is necessary that it be like this:
3
5
5
6
8
3
5
5
6
8
, etc.

If the product turns out to be 8000, then:
8
0
0
0
8
0
0
0
, etc.

What could be the solution to such a simple problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2022-04-07
@Shah_Alina

=TRANSPOSE(ARRAYFORMULA(REGEXEXTRACT(TEXT(REPT(A1;25);"0"); REPT("(.)"; LEN(REPT(A1;25))))))

Example
624ef6f587c67039541593.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question