I have data that looks like this:
0.id | 09231 |
0.date | 12/3/14 |
0.score | 5-2 |
1.id | 09232 |
1.date | 13/3/14 |
1.score | 3-0 |
2.id | 09233 |
2.date | 14/3/14 |
2.score | 1-2 |
And I would like to turn it into this:
id | date | score | |
0 | 09231 | 12/3/14 | 5-2 |
1 | 09232 | 13/3/14 | 3-0 |
2 | 09233 | 14/3/14 | 1-2 |
Would this be possible?
Thanks,
Liam
Solved! Go to Solution.
Hi @LiamSkop
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Given that your first column contains the row ID and the field name (header), you can use a text to columns to separate these. A period is the delimiter and it will be split into 2 columns.
From there, you can use a cross-tab to pivot the data. You would select the row ID field as a group by, so every ID will be a separate row. The second part of the field header will be the headers, and the second column of your original dataset will be the values.
You have to specify a method of aggregation should there be duplicates in the headers and group by fields. This won't do anything in our case since we don't have duplicates, so I just chose concatenate.
Hope this helps!
Thank you so much, that does it perfectly
Thank you, worked like a charm