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:
- Row 1: Event 1 | Event type 1
- Row 2: Event 1 | Event type 2
- Row 3: Event 1 | Event type 3
- Row 4: Event 2 | Event type 1
- 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:
- Row 1: Event 1 | Event type 1 | Event type 2 | Event type 3
- 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.