Ask Your Question
0

Calc - Pivot Table - arrange columnar data from multiple rows into one row

asked 2019-06-26 01:11:15 +0200

Carrbigdog gravatar image

Newbie with Pivot tables I have a spreadsheet with multiple rows per event and I would like to create a worksheet with one row per event with the values from cells in one column combined into one (or multiple) columns. If I can get a result with one row per event and multiple cells I can concatenate them into a single cell. My data looks like:

  1. Row 1: Event 1 | Event type 1
  2. Row 2: Event 1 | Event type 2
  3. Row 3: Event 1 | Event type 3
  4. Row 4: Event 2 | Event type 1
  5. Row 5: Event 2 | Event type 2

The number of types per event will vary from 1 to 8.

I would like have a result worksheet like:

  1. Row 1: Event 1 | Event type 1 | Event type 2 | Event type 3
  2. Row 2: Event 2 | Event type 1 | Event type 2 | null/empty

I have guessed that the way to accomplish this is with a Pivot table, but with all my trials and errors, I am unable to get the desired result. I either end up with multiple rows in the resulting spreadsheet, one line per event type or Event type is missing.
Q1: Are Pivot tables the answer to my dilemma? /n

Q2: Can you point me to a tutorial/previous answer that will explain in detail how to accomplish this.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-26 09:52:32 +0200

m.a.riosv gravatar image

I think pivot table not directly the solution but an intermediate step.

image description

C:\fakepath\SampleCombinateInRow.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-26 01:11:15 +0200

Seen: 41 times

Last updated: Jun 26