Answer the question
In order to leave comments, you need to log in
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. 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 questionAsk a Question
731 491 924 answers to any question