Hi there,

I have an excel file with data that has 7 columns and 912 rows. I want to take the first row and copy it into 10 rows. Then take the second row and copy it into the next 10 rows, and take the third row and copy it into the next 10 rows and so on for all rows.

Please download the file here https://fileexchange.imperial.ac.uk/.../RowtoRows.xls



In the attached file, on the left hand side I have my 7 columns and 912 rows (A2:G913) . To the right of this, I have created a sample of what I am trying to achieve. I have copy&pasted A3:G3 into J3:P12, also copy pasted A4:G4 into J13:P22 etc etc (this is what I am trying to achieve but for all rows)

What formula can I use to do this quickly as it will take a long time to copy&paste manually?

Thanks in advance.