Summarize

[AnGi]

HI guys, need your help

i have this table

Name	A	B	C
Paul	2
Mark	2
Steven	2
Andy	2
Paul		3
Mark		4
Steven		5
Andy		5

And i would like to summarize A and B in column C matching the name. Results should be like this

Name	A	B	C
Paul	2	3	5
Mark	2	4	6
Steven	2	5	7
Andy	2	5	7

Could you help?

Thanks

[Emil_Kos]

Hi @AnGi,

Summarize tool is the tool to use. Just keep in mind that your values need to be numbers to make it work. 

[AnGi]

@Emil_Kos 

Thanks Emil

what if the table is

Name	Surname	A	B	C
Paul	Smith	2
Mark	Clark	2
Steven	Tricky	2
Andy	Shannon	2
Paul	Smith		3
Mark	Clark		4
Steven	Tricky		5
Andy	Shannon		5
Mary	Kor	3		3
Julian	Sima		4	4

and results should be

Name	Surname	A	B	C
Paul	Smith	2	3
Mark	Clark	2	4
Steven	Tricky	2	5
Andy	Shannon	2	5
Mary	Kor	3		3
Julian	Sima		4	4

[Emil_Kos]

Hi @AnGi,

This should work for you:

[AnGi]

@Emil_Kos 

I have a little issue:

lets insert a new column ID that i use for GroupBy

ID	Name	Surname	A	B	C
1	Paul	Smith B.	2
2	Mark	Clark	2
3	Steven	Tricky	2
4	Andy	Shannon	2
1	Paul	Smith		3
2	Mark F.	Clark		4
3	Steven	Tricky		5
4	Andy	Shannon		5
5	Mary	Kor	3		3
6	Julian	Sima		4	4

If I GroupBy also for Name and Surname i dont have a unique results for ID and i would like to take column Name and Surname into results

[Emil_Kos · Accepted solution]

Hi,

I have assigned first name and first surname to each record ID:

The output: