Merge Rows and Sum Field Valies

RicardoVales

Hi,

I have a table where I have dates on the rows, and countries on Columns.
Like this:

	Country 1	Country 2
01/01/2018	1	4
02/01/2018	2	3
03/01/2018	3	2
04/01/2018	4	1
01/01/2018	7	8
03/01/2018	10	10

And I want to merge the rows that have the same value, and sum the value on the several columns.This would be the desired output.

	Country 1	Country 2
01/01/2018	8	12
02/01/2018	2	3
03/01/2018	13	12
04/01/2018	4	1

What is the best way to achieve this?

Thanks for your help!

RolandSchubert

Hi @RicardoVales ,

I think, the Summarize tool would do the job. I've attached a sample workflow. Hope this is helpful.

Best,

Roland

SumTable.yxmd