I have data that looks like this: 0.id092310.date12/3/140.score5-21.id092321.date13/3/141.score3-02.id092332.date14/3/142.score1-2 And I would like to turn it into this: iddatescore00923112/3/14 5-210923213/3/14 3-020923314/3/14 1-2 Would this be possible? Thanks, Liam

Groups of rows to columns

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

API

Accepted answers

atcodedog05

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 😀👍

shape.yxmd

All comments

atcodedog05

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 😀👍

shape.yxmd

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!

New Workflow1.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703