Values to column and 1/0

saivig

Hi All , 

I have data in the following format 

ID	Value
1	A
1	B
1	C
2	A
2	Z

I want to transform to this , can some one help I am brand new to Alteryx.

ID	A	B	C	Z
1	1	1	1	0
2	1	0	0	1

jamielaird

Hi @saivig 

This should do the trick!

Welcome to Alteryx, shout if you have any questions.

Cross tab with 1s and 0s.yxmd