In a column, i have the numbers 4,2 and i need it to repeat for 100 rows in the same pattern
4
2
4
2
4
2
4
2
what is the fastest way to copy and paste that or fastest way to accomplish this? this numbers will be used in multiplication IE
4 3
2 5
4 2
2 9
so next to it will be the product
4 3 12
2 5 10
etc
etc
thanks
Bookmarks