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...
If your data is as per the screenshot below, you may try something like this...
In B1
=INDEX(A:A,QUOTIENT(ROWS(A$1:A1)-1,4)+1)and then copy it down.