data summarize

[TonyMu]

Hello, 

I have an input data as folow: 

A	1
B	3
B	5
A	2
C	1
B	3
A	2
A	1
B	2
C	3

I want to summorize it as follow: 

A	6
B	13
C	4

How do I do this in Alteryx? 

Regards, 

Tony

[OllieClarke]

Hey @TonyMu like the name suggests, the Summarize tool can do this for you. Set it up as below (grouping by the ABC, and summing the numbers)

Hope that helps, Ollie

[TonyMu]

Great, thanks for your very fast reply 🙂

Is there anyway for summerizing as bellow as well? 

from this: 

A	1	Null	Null
B	Null	2	Null
A	Null	Null	4
B	Null	Null	3
B	1	Null	Null
A	Null	2	Null

to this: 

A	1	2	4
B	1	2	3

thanks in advance, 

Tony

[Emil_Kos · Accepted solution]

Hi @TonyMu,

This is what you have been looking for? 

[Emil_Kos]

Hi @TonyMu,

Thank you for marking my post as a solution.

I am happy that I could help you!