I have an excel document with 5 columns (A through E) and 21,000 rows. Some of the rows contain information about the same person (in those, columns a-first name and b-last name would be the same in each row).
column d is a QTY number. I need to consolidate each of the matching rows to one QTY value.
A1and A2, first and last name, are also the same in A2 and B2 and A4 and B4. I want to consolidate each and ADD THE TOTAL in column d for each of the merged rows.
Does that make sense? Is it doable?
Solved by A. A. in 15 mins