table conversion to MATRIX

[Bordin_Wanichodom]

dear all alteryx users,

I would like to convert the table here below into matrix form

Table form:

Matrix form:

highly appreciate all support

[DanielMS · Accepted 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

[wdavis]

Hi @Bordin_Wanichodom 

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

[Bordin_Wanichodom]

Thx bro