Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question