Forum Discussion
Copy data to a new column
I have a column which has lots of information in it what I’m trying to do is copy the information ie:email addresses which appears every 18 rows down onto a separate spreadsheet. I also need to copy t...
Hi Wayne,
Assuming in start copying your data into the cells starting from first row, the formula for names could be
=OFFSET(Sheet1!$A$1,ROW()*18-6,)
and for emails in next column of the same row
=OFFSET(Sheet1!$A$1,ROW()*18-5,)
drag these cells down