One way:

B1: =INDEX(A:A,(ROW()-1)*3+1)


Copy down.

In article ,
Arlene wrote:

need step by step instructions to extract data from column A starting with A1
and grab A4, A7, A10, A13, etc.