Ask Your Question
0

How to reorganise data in calc according to factors in columns [closed]

asked 2014-02-04 16:29:21 +0200

chtfn gravatar image

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?

reorganise data.ods

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 06:32:51.463135

1 Answer

Sort by » oldest newest most voted
1

answered 2014-02-04 23:10:47 +0200

w_whalley gravatar image

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

edit flag offensive delete link more

Comments

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!

chtfn gravatar imagechtfn ( 2014-02-05 01:54:02 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-02-04 16:29:21 +0200

Seen: 64 times

Last updated: Feb 04 '14