I have a bunch of numbers in a column in excel like this:
and I want to have about 1000 sets of 1,2,3. I tried selecting them and dragging them down but all I got was a bunch of weirdness like this
Two questions. Why does the drag down method not work here as I vaguely remember doing something similar in the past and it worked then?
How can I easily reproduce a lot of these 1,2,3's down the column