I'm working in a spreadsheet that has duplicate items with corresponding values to the items, and i'm trying to consolidate them.
I have a free cell in "C1" where i would like to aggregate values of duplicate items.
Where I'm having trouble is aggregating the data into the open cell. I know...