This might be difficult to get, but attached is an example, with on the left the original data and on the right the desired result.
I have several columns of factors and one column of variable. All the combinations of factors exist. I want to reorganise the data so instead of one variable column, I get the data split between different columns corresponding to the different values of one particular factor.
How do I do this in Calc?