I have a list of (unique) numbers which I want to drag on another column but have it repeat each an X number of times.
Column A: current data;
Column B: desired output for X=2;
--------------------------------------------------
| | A | B |
--------------------------------------------------
| 1 | Number | Repeat number twice |
--------------------------------------------------
| 2 | 123 | 123 |
--------------------------------------------------
| 3 | 231 | 123 |
--------------------------------------------------
| 4 | 444 | 231 |
--------------------------------------------------
| 5 | 312 | 231 |
--------------------------------------------------
| 6 | 543 | 444 |
--------------------------------------------------
I want a way of dragging down starting at B2 all the way down to B:1000 and repeat each number in column A an X amount of times.