» Repeat entries in a column
If you have entries like these in a column which need to be repeated a certain number of times (for e.g. 4 times), try the formula given below the table -
The formula is =INDEX($A$2:$A$1000,CEILING(ROW(A1)/4,1))
Here the ceiling is shown as 4 because we want the value to be repeated 4 times.
This is how it will appear -