Groups of rows to columns

[LiamSkop]

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

[atcodedog05 · Accepted 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 😀👍

[echuong1]

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!

[atcodedog05]

Happy to help 🙂 @LiamSkop 

Cheers and Happy Analyzing 😀

[LiamSkop]

Thank you so much, that does it perfectly

[LiamSkop]

Thank you, worked like a charm