Transposing rows to columns

[Rubens75]

Hello everyone,

Without further due, here is the table I currently have :

Type of document	Country	Number of documents
Type 1	Country A	2
Type 1	Country C	4
Type 2	Country A	3
Type 3	Country B	7

This is the table I would like to have after Alteryx worklow :

Type of document	Country A	Country B	Country C
Type 1	2		4
Type 2	3
Type 3		7

Any ideas of how to do this easily in Alteryx ?

Thanks in advance,

Best,

Rubens

[JosephSerpis · Accepted solution]

Hi @Rubens75 you just need to use a crosstab tool and use the configuration below to produce that output.

[Rubens75]

Thanks, works perfectly !