As shown in the figure:
Formula: =INDEX(A:A, (ROW()- 1)*6-5)
By adjusting the values inside, you can refer to different rows and columns.
Note: You can enlarge the picture by opening it on a new web page.