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
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])
Hello Apathetichell,
Sorry, this is my first post, I added the data.
Thank you very much.
Phil
The steps worked like a charm, thank you very much!
That was way easier than expected 😉
@PhilThis is one of those scenarios where Alteryx really really shines.