Use names.
Assuming your data looks like this:
Data Results
1 1
2
3 1
4 2
5 3
6 4
7 5
8
9 1
10 2
Select all and
Insert Name Create Top Row
The formula for the first cell in Results is
=INDEX(Data,1)
and for the second block in Results
=INDEX(Data,1):INDEX(Data,5)
and an alternate formula for the last block
=OFFSET(Data,0,0,2)
The last two are array formulas entered with
Shift+Ctrl+Enter.
You can copy the Results to any row or column
without changes.