If you have used formulas it is not possible to use transpose function. You receive a #REF error. Does anyone have an idea or trick to make this possible?

Greetz,
Bjorn