HELP

[Roozo]

The above explains everything great, however i do not have the same number
rows in each set of data, e.g.

A1 address 1
A2 address 1
A3 address 1
A4 address 1
A5
A6 address 1
A7 address 1
A8 address 1
A9 address 1
A10 address 1
A11 address 1

etc, etc.

So when i use the below formula it messes up the data range - any ideas if
this can be accounted for in the formula?

Thanks



Assume that the values start in Sheet1!A1, insert a new sheet (or use
another sheet that is empty) and put this in A1

=INDEX(Sheet1!$A:$A,ROWS($A$1:A1)*7+COLUMNS($A$1:A1)-7)


copy across 7 columns and then copy down