- I have to enter tens of thousands of number ranges
- There are various columns and each number range includes 10 numbers (00-09, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99).
- There is only one column that needs to be changed for each number range. I have the various values that need to be changed in another spreadsheet.
- The problem is that I would have to copy it 10 times for each range (Ex1 00-09, Ex1 10-19, Ex1 20-29, Ex1 30-39, Ex1 40-49, Ex1 50-59, Ex1 60-69, Ex1 70-79, Ex1 80-89, Ex1 90-99).
Example:
A1 B1 C1
Ex1 00 09
Ex1 10 19
Ex1 20 29
Ex1 30 39
Ex1 40 49
Ex1 50 59
Ex1 60 69
Ex1 70 79
EX1 80 89
EX1 90 99
Ex2 00 09
Ex2 10 19
Ex2 20 29
Ex2 30 39
Ex2 40 49
Ex2 50 59
Ex2 60 69
Ex2 70 79
EX2 80 89
EX2 90 99
Ex3 00 09
Ex3 10 19
Ex3 20 29
Ex3 30 39
Ex3 40 49
Ex3 50 59
Ex3 60 69
Ex3 70 79
EX3 80 89
EX3 90 99
And so on and so forth...
How to I take a single value and duplicate it 10 times into Column A, while leaving the rest of the data (number ranges) static?
Thanks in advance.
Bookmarks