I have a table that looks much like this:
That Category column is entered manually and will have several duplicated values.
I’d LOVE to be able to create a “Summary” table that manages to copy and manipulate some of this data. Namely:
- It would take the “Category” columns with its duplicates, remove duplicated and sort the list;
- Have a second column that sums all values in that category’s fields;
- And finally, have a third row that shows how many times the original keywords appeared in the first table.
Here is a screenshot of what I’m trying to achieve: