Creating columns based off sub-rows
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jhwth
6 - Meteoroid
‎04-03-2023
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have an input table like below that is unformatted; essentially, there are sub-rows containing currency values:
Column 1 | Column 2 |
Item 1 | |
Currency 1 | 100 |
Currency 2 | 150 |
Currency 3 | 25 |
Item 2 | |
Currency 1 | 500 |
Item 3 | |
Currency 3 | 100 |
Currency 4 | 100 |
Is there a way to group column 1 so that Column 1 shows the items while the different currency types becomes new columns? Essentially, the output needs to be something like this:
Item | Currency 1 | Currency 2 | Currency 3 | Currency 4 |
Item 1 | 100 | 150 | 25 | 0 |
Item 2 | 500 | 0 | 0 | 0 |
Item 3 | 0 | 0 | 100 | 100 |
Labels:
- Labels:
- Datasets
- Preparation
- Tips and Tricks
- Workflow
1 REPLY 1
Clifford_Coon
11 - Bolide
‎04-03-2023
01:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
