I have a spreadsheet that lists names in one column and a number in the second column. In the name's column, some names are listed multiple times. What i am trying to do in my query is list the name once and then do a sum for all numbers in the second column associated with that name. I thought i could use the Distinct function, but it continues to list the names multiple times. There are other columns in the spreadsheet and the data is different for each similar name so unsure if that is not allowing me to combine them even though i am not pulling those fields into the query.
I have attached a sample database with mock info. Below is what i am trying to obtain.
Test1 - 2
Test2 - 4
Test3 - 6
I know it is simple, but i am just stuck.