Home

Copy data to a new column

Highlighted
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies