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.
|