Merge duplicate rows and combine data in some of the same columns

Have spreadsheet with multiple columns and rows. Where the data in column C matches another in column C, want the information in columns in E:I to be added together. Information in columns A, B, K and L will be the same and should be retained.

Therefore in the example spreadsheet attached, cells E8 - I9 would be added together, likewise E18 - I19 and row 9 and 19 would disappear.

Help appreciated to run a macro to achieve.

KenBook4.xlsx

try

Please Login or Register  to view this content.

Excellent - works great - thanks jindon