Not to me.



In your first message you wrote:

The reason this is difficult is because my data is setup like this:

Product 1 Product 2 Product 3
Size 1 1 2 3
Size 2 4 5 6
Size 3 7 8 9

and i'm trying to orient it like this (Hence all the offset formulas):

Size 1 Size 2 Size 3
Product 1 1 4 7
Product 2 2 5 8
Product 3 3 6 9

My formula does exactly what you ask for above.

My apologies,

I didn't quite understand your response at first. I used the formula you provided and it worked.

Thank you very much--you have saved me a lot of time.

Cheers!