Hi,

How do I duplicate the values to say 4 times in a column?

So I have in a column,

dog
cat
bird
fish

I want to duplicate the above to look like this below,

dog
dog
dog
dog
cat
cat
cat
cat
bird
bird
bird
bird
fish
fish
fish
fish

I'll need to do this for 500 unique values 12 times each, so is there a formula to do this easily?

Thanks in advance!