How to achieve this in Alteryx? Thank you in advance.

[Kketan24]

Input

Region	Stage	Amount
AP	Hold	$25
AP	Hold	$25
EUR	Assign	$10
EUR	Hold	$10

Output

Region	Hold	Assign
AP	$50
EUR	$10	$10

[alexnajm · Accepted solution]

Crosstab - Group by Region, headers are Stage, values are Amount, and aggregation should be Sum. Make sure your Amount column though is numeric

[Kketan24]

Thanks @alexnajm. That worked! :)

[Kketan24]

Hi@alexnajm,

Could you please help with the below as well?

Input::

Region	Customer	Status
AP	ABC	L
EUR	XYZ	H
LAC	PQR	L

Output

Region	AP	EUR	LAC
Customer	ABC	XYZ	PQR
Status	L	H	L

[alexnajm]

I am not sure this layout makes sense to do - for example, why would Customer be on the second line? And where did the headers go?

Try to learn about these tools first - I highly recommend this interactive lesson to learn about the Transpose/Crosstab tools further: Changing Data Layouts - Alteryx Community

If you are still stuck, post another discussion question about this as this one should be focused on the original question

[Kketan24]

Sorry, I have corrected my o/p.

[alexnajm]

Looks like you got help in the other post!