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.

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.

asked March 12th 20 at 08:00

1 answer

answered on 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"

or

2B. =SUMIF or =SUMMERLIN

2A. Then "pivot table"

or

2B. =SUMIF or =SUMMERLIN

Find more questions by tags Google Sheets