The Cross Tab and Transpose tools allow you to make transformation on the structure of the table.

Cross Tab is very useful when you need to have categorical data. With the Cross Tab you will be able to divide the data into mutually groups as you can see the example below:

The transpose is the opposite of Cross tab. It can Pivot multiple columns keeping the previous names and values and creating more rows.

The Cross Tab layout is good to look at the table by itself but is not helpful to make chart using this table in tableau and that is the reason where the transpose will be helpful.

Now let’s see how to do the Transpose and the Cross Tab in Alteryx.


In the configuration window select a “key Fields” that won`t rotating. Therefore, it will keep fixed. The other that is not selected will rotate and then will be created two columns with the header called “Name” and “Value” as we can see at the example below:

Cross Tab:

Similar when we transposed the table, the configuration needs to be set. We want to select a key column that won’t rotate in the “Group Data by these values” in the box to keep it fixed. Now we need to select the column “Name” to be the header in the “Change Column Header” box and then we need to select the column “Value” in the values for the new columns box to populate the columns. Also, we need to choose the “Method for Aggregating Values” in the last box.

This is the Transpose and Cross Tab Processes. I hope this blog may be helpful to understand these two tools better.