Transform 1 Column to Row Headers and populate with values from separate column

Question

Hello Community,

I'm trying to transform the data of one column of a table to headers and populate them with the corresponding data from another column, while keeping other information.

I want to get from here:

to here:

Thank you very much for your help!

Phil

Alteryx - Community question 1.xlsx

apathetichell · Answer

@PhilThis is one of those scenarios where Alteryx really really shines.

Phil · Answer

The steps worked like a charm, thank you very much!

That was way easier than expected 😉

apathetichell · Answer

No problem - Try going through the steps I outlined with your data and if your stumbling take a look at what I attached.

first community question crosstab.yxmd