There are two general ways to do this, depending on data.
If the spacing is exact meaning that the number of rows does not change at all, then the offset command would be easiest.
If the data is on sheet 1, on sheet 2
enter the first two lines of headers.
- use naming to name sheet1!$a$1 as Spot or any other name you like
- use naming to name 5 as Step
- use naming to name Pik as =+((COLUMN()-2)*Step)+(ROW()-1)
then use in b2 and extend as far as needed
=+OFFSET(spot,Pik,1)
this pulls in all the data.
There are a couple of flaws with this, the biggest one is it will break if a single extra line or other minor mod occurs midway through data. There is another way of using a search function type approach where we look for a key data (Name, Age, etc.) and return the info from the next cell. It is more complicated. I may write it up later.