Oct 19 2018 07:24 AM
Oct 20 2018 05:51 AM
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