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!
There's a few ways to do this:
=TOCOL(CHOOSECOLS(C1:C3,{1,1}))
or
=TOCOL(HSTACK(C1:C3,C1:C3))