I have a sheet which has a list of numbers in column A. Each number appears only once but I need each number to appear 6 times.

So, this....

432740093
412620001
412620002

Would become...

432740093
432740093
432740093
432740093
432740093
432740093
412620001
412620001
412620001
412620001
412620001
412620001
412620002
412620002
412620002
412620002
412620002
412620002

Is there a simple formula for this procedure?

Any help would be greatly appreciated

Regards