Alteryx Column Sort Help

Hi There

Can you help? I need to group the id and key columns shown in grey below by their component description and value...

So my data will go from

THIS......

column orig.png

TO THIS

column required.png

Any help would be great

column orig.png

column required.png

column grouping request.xlsx

Preparation

Data Investigation

Accepted answers

alexnajm

Looks like a crosstab tool! Followed by a few more since the groupings are interesting... this workflow would get you there but assumes you only have two values for each id-key grouping

Alteryx Column Sort Help.yxzp

binu_acs

@DelData similar approach to @alexnajm

Transpose_23042024.yxmd

All comments

alexnajm

Looks like a crosstab tool! Followed by a few more since the groupings are interesting... this workflow would get you there but assumes you only have two values for each id-key grouping

Alteryx Column Sort Help.yxzp

binu_acs

@DelData similar approach to @alexnajm

Transpose_23042024.yxmd

alexnajm

Smart @binu_acs ! I like your solution much better than mine

DelData

Thank you both......this fixed my issue and both your answers work so thank you for taking time to help me out

DelData

Thank you......this fixed my issue and both your answers work so thank you for taking time to help me out

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703