Data transformation - on Alteryx

Question

Hi I am trying to transform the following data

TeamQuestions?ResponseAIs it okay?NoAAll good?NoAYes or No?NoAUpdated?YesARefreshed?YesBIs it okay?NoBAll good?YesBYes or No?NoBUpdated?NoBRefreshed?YesCIs it okay?NoCAll good?NoCYes or No?YesCUpdated?YesCRefreshed?YesDIs it okay?NoDAll good?NoDYes or No?NoDUpdated?YesDRefreshed?Yes

as below:

TeamIs it okay?All good?Yes or No?Updated?Refreshed?ANoNoNoYesYesBNoYesNoNoYesCNoNoYesYesYesDNoNoNoYesYes

Can someone please help

caltang · Answer

Something else, longer than @DataNath 's

For Sahadh.yxmd

DataNath · Answer

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:

Data transform and clean headers.yxmd

MilindG · Answer

@SahadhKuruniyan

Data transform.yxmd