Forum Discussion
Copying cells from one column to multiple rows in a different column
I have a large data set where I need to take several rows from one column and copy each row n amount of times to a different column. To be specific, lets say in column A, I have: 1 2 3 4 I...
In B1:
=INDEX(A:A,(ROW()-1)/4+1)
Fill down.
Alternatively, enter the number of repetitions in a cell, for example C1, and use
=INDEX(A:A,(ROW()-1)/$C$1+1)
You're welcome! Glad we could help.
