Hi,

Put this in E1 and drag down as far as required

=INDIRECT("A"&2+(ROW(A1)-1)*4)

Mike

"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