Data transformation - on Alteryx

[SahadhKuruniyan]

Hi I am trying to transform the following data 

Team	Questions?	Response
A	Is it okay?	No
A	All good?	No
A	Yes or No?	No
A	Updated?	Yes
A	Refreshed?	Yes
B	Is it okay?	No
B	All good?	Yes
B	Yes or No?	No
B	Updated?	No
B	Refreshed?	Yes
C	Is it okay?	No
C	All good?	No
C	Yes or No?	Yes
C	Updated?	Yes
C	Refreshed?	Yes
D	Is it okay?	No
D	All good?	No
D	Yes or No?	No
D	Updated?	Yes
D	Refreshed?	Yes

as below:

Team	Is it okay?	All good?	Yes or No?	Updated?	Refreshed?
A	No	No	No	Yes	Yes
B	No	Yes	No	No	Yes
C	No	No	Yes	Yes	Yes
D	No	No	No	Yes	Yes

Can someone please help

[MilindG]

@SahadhKuruniyan 

[DataNath]

Hey @SahadhKuruniyan, you just need a simple Cross Tab here! This will lead to underscores due to the special characters in the name, though, so I've added an extra step where we dynamically rename the fields back to what they should be:

[caltang]

Something else, longer than @DataNath 's