Excel: how to duplicate every row into the same column?

Solution 1:

With data in column A, in B1 enter:

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

and copy downward.

enter image description here

Notice you get two copies of each item. If you use 3 in the formula, you would get three copies of each item.