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.