Forum Discussion
Excel - Duplicate cells into another column
I am looking for a formula to take data in one column and copy/create a duplicate in another column.
Example:
C
48
60
72
Becomes:
D
48
48
60
60
72
72
Thanks!
=INDEX($C$2:$C$9,ROUNDDOWN((ROW(A1)-ROW($A$1))*0.5,0)+1)If you work with e.g. Excel 2013 you can use this formula.
There's a few ways to do this:
=TOCOL(CHOOSECOLS(C1:C3,{1,1}))or
=TOCOL(HSTACK(C1:C3,C1:C3))
