This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
dear all alteryx users,
I would like to convert the table here below into matrix form
Table form:
Matrix form:
highly appreciate all support
Solved! Go to Solution.
Hi @Bordin_Wanichodom ,
You can do this by using the cross-tab tool in the transform category.
In the configuration of the tool you will need to:
- Group by Company
- Set New Headers as Transportation
- Set Values to Frequency
- Choose the Sum aggregation method
Kind regards,
Dan
As @DanielMS said, the Cross-Tab tool can easily achieve this for you.
See attached workflow for the configuration you can copy to your workflow.
Thanks
Will
Thx bro