Create columns based on values of a specific column

[md666]

Hello,

I want to prepare my data for advanced analytic and need to transform my data but could not find a solution yet.

Data looks like:

UserID	Test	Value	Unit
1	A	3.0	dl
1	B	2.0	cm
2	A	1.0	dl

Results should look like this:

UserID	Test A Value	Test A Unit	Test B Value	Test B Unit
1	3.0	dl	2.0	cm
2	1.0	dl

[Claje · Accepted solution]

Hi,

I think you can accomplish this with a Transpose tool and a Cross Tab tool.  I've attached a workflow that I believe accommodates this transformation.

Hope this helps!

[md666]

Thanks a lot, this solved it perfectly!