How to integrate values publichow one?

I have a list
For example:
Peter 4
Sasha 4
Peter 3
Sasha 2
Dan 1
Sonia 2
Sonya 3
And there are more than 7 thousand, how do I integrate all in one Sash all Sing one and so on.
That is, what would five hundred of the sash there is one which includes the values of all other sash.
March 12th 20 at 08:00
1 answer
March 12th 20 at 08:02
1. First split the text to columns (space delimited. If you have a lot of words and a lot of gaps - it was better to give a real sample)

2A. Then "pivot table"

Find more questions by tags Google Sheets