How to Split columns

[hcho2]

I need help with using Cross tab function.

Currently, I want to transform from following:

Name	Value
A2	A21
A2	A22
A2	A23
A1	A11
A1	A12
A1	A13

To this:

A1	A2
A11	A21
A12	A22
A13	A23

However, the use of cross tab tool is so confusing for me.

I have attached the workflow with container in the area I need help.

Thank you!

[alexnajm]

You may need another column to Group By so that the data doesn’t get concatenated - likely a Multi Row Formula will do it but maybe you can put in a Record ID tool earlier (I’m on my phone so can’t open the file, although I’m curious why it’s a .yxmc)

other than that, [Name] is your column header, [Value] is your value, and likely concatenation is your aggregation method

[binuacs · Accepted solution]

@hcho2 one way of doing this