Combining Multiple Rows

[Riot]

Hello all,

Its great to be back on Alteryx, using it in a real world application as opposed to a class setting, but perhaps I have lost a bit and need to freshen up. 

I am analyzing the response rate of mail cards.

I have a list of every order to a show, but some of them have multiple purchases.  So if 12,000 were sent out and I have 3,000 purchases but only 2,500 are unique, it will throw off my rate. 

What I am trying to do is turn: 

John    Smith       2      100 

John    Smith      1        50 

Into:

John   Smith       3        150  

Is this possible ? 

[michael_treadwell · Accepted solution]

Summarise tool

Group by First Name and Last Name. Then choose sum for the other two columns.

[Riot]

haha thank you, I cant believe i forgot that.