Here is what i need to do:
For example i have initial data with two columns. In first column i have some values, that can repeats. At second column - values that corresponds to each value of first column.
The task is:
- Filter first column with unique values.
- Summarize relative values from the second column.
At the image i did a manual example.
Now i use the execel's filters to range alphabetically. Then manually copy only unique values from first column and manually summarize from the second. Please help how it could be easier?)