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

[Phil]

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

[apathetichell]

Post this as data (ie not as a .png of data) if this doesn't work but use a cross tab tool.

group data by Company and Sector, columns are Metric, value is Value ([first])

[Phil]

Hello Apathetichell,

Sorry, this is my first post, I added the data.

Thank you very much.

Phil

[apathetichell]

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

[Phil]

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

That was way easier than expected 😉

[apathetichell]

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