I have a spreadsheet with similar items in different rows. Each item has a unique value. For example:
I want to create a table that has one row for each of the similar rows (e.g., /ca/motion-type/abstract-4), and a sum of the values in the second column (e.g., 30).
Any idea how I can do this in Excel?