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.