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.