Alteryx Column Sort Help

[DelData]

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......

TO THIS

Any help would be great :)

 

[alexnajm · Accepted solution]

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

[binuacs · Accepted solution]

@DelData similar approach to @alexnajm 

[alexnajm]

Smart @binuacs ! 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 :)