Get instant live expert help on I need help with excel consolidate rows
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a an excel spreadsheet that has many rows of different data. I need an excel function that will consolidate rows based off of them being identical.
Solved by V. H. in 11 mins
consolidate rows by sum thank you very m
Solved by C. J. in 29 mins
need to consolidate records in excel
one employee
Solved by O. C. in 29 mins
I can not use Consolidate function in Excel
Solved by E. E. in 16 mins
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.
For example,
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