Thanks a ton! very informative and helpful.

"Gary''s Student" wrote:

In E1 enter:

=INDIRECT("A" &4* ROW()-2) and copy down
--
Gary''s Student - gsnu200901


"Confusicous" wrote:

I have a list of names in Column A and the names appear every 4 lines down.
A2, A6, A10... In column E I just want the names to appear and this has 6,000
lines on the spreadsheet. Can anyone tell me the easiest way to get this to
work out.

Thanks