I have a speadsheet that includes multiple rows with redundant data that I need to consolidate into summary lines. For example, let's say I have the following ten rows (in three columns): 20 March Soybeans 25 March Soybeans 15 May Soybeans 93 May Soybeans 42 July Corn 11 July Corn 32 July Corn 431 July Corn 16 September Corn 32 September Corn and I want those lines to consolidate into: 45 March Soybeans 108 May Soybeans 516 July Corn 48 September Corn or even: 153 Soybeans 564 Corn Can this be done without manually inserting a sum function between each different month and/or commodity? I'm used to creating AS/400 queries where stuff like this is a breeze but now I'm being given the data in spreadsheet format and I'm having a tough time producing the same results. Someone I know mentioned a "pivot table" function in Excel, but I tried it and it didn't quite give me the results I need (the data I'm working with has many more rows and columns than the example above so the pivot table was unwieldy--we're talking about thousands of rows). Thanks!