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?
A pivot table will do the job, at least for the small data set you presented. Here are some sources of pivot table information: create pivot table, wiki, chapter 8, using pivot tables.
With your sample data I put Factor 1 and Factor 2 in the Row Fields, Factor 3 in the Column Fields and Sum - Values in the Data fields. If your factor combinations are unique, then the sum will work.
Result:Pivot.png
Great, thank you for that w_whalley! It works. I wished it would just reorganise the data and not reformat everything, but this will do for the moment 
As you said, it would be great to have a tool that is more straight-forward and would work in the case the factor combinations are not unique.
Cheers!
