Alteryx help - pivoting data

[lwey3]

Need help converting the data in a table below (table 1) to (table 2), similar to a pivot table function in Excel. Thanks in advance.

Table 1

Account Name	Amount	Month
GL 1	5	Jul
GL 2	10	Jul
GL 3	20	Jul
GL 1	15	Aug

Table 2

Account Name	Jul	Aug
GL 1	5	15
GL 2	10	etc.

[Qiu]

@lwey3 
Try with a CrossTab tool😁

[lwey3]

Thanks - how are you configuring this?

[Qiu]

@lwey3 

It should be something like this.