How to rearrange data

[air0storm]

Hi community,

I can't quite figure out what should be a relatively simple transformation. My data is structured like this.

Group	Person
1	A
2	B
3	C
4	D
1	E
4	F
3	G

I want the output to be

1	2	3	4
A	B	C	D
E		G	F

I thought about cross-tabbing using a concatenate function and then doing "text to rows". But in practice there are a lot of groups, not just 4, so I was hoping there was a more practical solution.

Thanks!

[AngelosPachis]

Hi @air0storm 

First of all, that's one great username. Secondly, I've mocked up a workflow that answers your question, you just have to create a field that you will group on, before you cross-tab

Workflow: 

Output

Hope that helps

Regards,

Angelos

[BrandonB · Accepted solution]

You will want to use a multi row tool to make kind of like a record ID within each group. Then when you crosstab you can group by this new field and it will rearrange the data as you are looking for. Workflow is attached. 

  

[air0storm]

Worked like a charm, thanks a lot for the help!

I couldn't quite figure out how to make that record locator.