Ask Your Question
0

Is there any way to pivot data in Calc without aggregating?

asked 2019-09-17 20:37:37 +0200

ekolis gravatar image

I have some raw survey data I want to pivot that looks similar to this:

image description

And I want to pivot the questions into columns:

image description

But when I do so, I don't get the answers in the pivot table cells, even though there is only one answer per combination of name and question.

Is there any way for me to get the answers to appear in the pivot table cells?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-09-19 01:20:30 +0200

@ekolis ,

With PivotTable I have no solution, but by formulas and validation yes.

Follow suggestion

-----------------------------------------------------------------------------

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

Comments

Oh, that's pretty neat! Is there any way to make the names and question headers dynamic (i.e. look them up from the original data set) rather than having to enter them in manually? My actual data set has quite a bit more than three people and three questions! :)

ekolis gravatar imageekolis ( 2019-09-19 20:16:46 +0200 )edit

Following is review, created two columns to work on Plan1 and Plan2 copy rows or columns to enlarge.

Revised File

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-09-19 21:31:15 +0200 )edit
0

answered 2019-09-18 01:03:48 +0200

m.a.riosv gravatar image

updated 2019-09-18 23:39:24 +0200

Move the 'Question' to a column field on the PT, by dragging or editing the PT properties.

Edited 20190918

Using a PT as intermediate table to get the names in column and the question in rows.

C:\fakepath\RestructureTable_PT.ods

edit flag offensive delete link more

Comments

I did that, but all the data cells (Sum - Answer) come up blank.

ekolis gravatar imageekolis ( 2019-09-18 21:39:31 +0200 )edit

Sorry my bad, it needs more work to get it.

m.a.riosv gravatar imagem.a.riosv ( 2019-09-18 23:37:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-17 20:37:37 +0200

Seen: 30 times

Last updated: Sep 19