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.
Notice you get two copies of each item. If you use 3 in the formula, you would get three copies of each item.