Well, you have to get it in a more normalized form first. You could use DSUM() to add the matching values up for you, but you'd still have to know each of the names beforehand, and I can't think of any way to do that. I don't think that Excel provides a way to put values in multiple cells with a single function, which is what you'd have to do in order to get all the unique names. Perhaps there's some VB something you could do within Excel, though.