D
D
Delraid2018-10-09 18:48:14
Google Sheets
Delraid, 2018-10-09 18:48:14

How to combine duplicate values ​​into one?

I have a list
For example:
Petya 4
Sasha 4
Petya 3
Sasha 2
Danya 1
Sonya 2
Sonya 3
And there are more than 7 thousand of them, how can I unite all Sashas into one all Sing into one and so on.
That is, so that out of five hundred sashes there is one left that includes the values ​​of all the other sashes.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Kiselyov, 2018-10-10
@zamboga

1. First, divide the text into columns (the separator is a space. If you have a lot of words and a lot of spaces there, you should have given a real sample right away)
2a. Then "pivot table"
or
2b. =SUMIF or =SUMIF

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question