I have a column of numbers

1
2
3
4
5


And I want to create a new column where each number is repeated a certain number of times (let's say 5 here, but for me, it will actually be 9 times)

1
1
1
1
1
2
2
2
2
2
etc...

This list is long to start with (600+), so I can't click and drag each entry. Is there anyway I can split cells vertically and have the contents copy into the new rows? Or any other suggestions?

Thanks

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.

Quote:

---

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?

Nope, But this is an example of why its better to be more detailed in your question. Had you explained exactly what you are dealing with I wouldn't have wasted both our time on a solution that wouldn't work. So now you should explain in FULL detail what you really need and maybe I can offer a solution.