I am trying to get the spreadsheet to auto fill a sequence of numbers starting with 1 and ending with 70000. Each number should repeat 30 times as counted out in column c and then change to the next number in sequence for a total of 2.1milion lines.
I have tried to highlight and drag but it does not autofill the correct sequence is there anyway to do this?
Thanks