Ok I want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent. [Category, Price] [Gas , $50] [Grocery , $80] [Lunch , $15] [Gas , $34.50] What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool.