Hi Claus

Thank you for your patience.

No idea why the index Match did not work for me, but it is now working thank you.

I see where there is the issue in the transposing.

Only column A has the Unit No's. They are not repeated in G , M, etc.

The array spacing are as follows:

| Week | Unit | Rows |
|______|________|_______
|..1...|Company.|...9..|
|......|........|..22..|
|______|________|______|
|..1...|Subby...|..27..|
|......|........|..46..|
|______|________|______|
|..2...|Company.|..55..|
|......|........|..68..|
|______|________|______|
|..2...|Subby...|..73..|
|......|........|..92..|
|______|________|______|
|..3...|Company.|.101..|
|......|........|.114..|
|______|________|______|
|..3...|Subby...|.119..|
|......|........|.138..|
|______|________|______|
|..4...|Company.|.147..|
|......|........|.160..|
|______|________|______|
|..4...|Subby...|.165..|
|......|........|.184..|
|______|________|______|

Etc......

Appreciate your help.

Cheers
Mark.