Duplicate every row into the same column in Excel

This is superb! Thank you so much. Stay blessed. 😃

👍👏👏

IT DOESNT WORK, MY FRIEND

Not all heroes wear capes, thank you so much!

Thank you!!!

Is there any way to duplicate multiple columns instead of only 1 ?

thanks!

Very helpful. Thanks soooo much

=INDEX(A:A,ROUNDUP(ROWS($1:1)/2,0))