Originally Posted by
ScottGem
Splitting won't work. You can do this with patterns. Type in 9 rows of 1s then 9 rows of 2s. Select the 18 rows, then click on the box in the lower right corber and drag down the 600 rows. This will fill in the range with rows of 2s, 3s, etc. You might have to convert to the Int value to remove decimals. But this is the easiest way.
That won't work in my case. I simplified my problem for the post... the issue is these numbers are not in sequential order.
That is, I have a column of directions (NW,SW,NE,SE) corresponding to numbers 1-4. These are randomly occurring. So my list looks more like:
2
3
4
3
3
1
4
etc.
Is there any way to handle this?