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