Home

Copy data to a new column

Wayne Sluman
Occasional Visitor
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 the name and phone numbers which also appear every 18 rows down. So the first email address is A14 the next email address is A32 and so on. Same with the name, the first name is A13 and the next name is A31. So what I need is a formula or something to take that information so that it shows all the first names in one column matching up to all the appropriate email addresses. HELP.
1 Reply

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