Convert long data to wide -Crosstab data, update column headers, cell data values with 0,1

kalash47

I have the following use case-

Input data-

User	Question	Answer
A	Q1	a
A	Q2	x
A	Q2	y
A	Q2	z
B	Q1	c
B	Q2	p
B	Q2	q
B	Q2	x

Required output-

User	Q1	Q2_x	Q2_y	Q2_z	Q2_p	Q2_q
A	a	1	1	1	0	0
B	c	1	0	0	1	1

Please help!

FrederikE

Hey @kalash47,

This is how I'd do it. 

Edit: If you want Q1 to include the "c/a" instead of 1, you can remove it in the multi-field.

New Workflow2.yxmd