Hello,
I am having trouble consolidating a worksheet by 2 columns but keeping the data in all the other columns once the consolidation is complete. I would like to write a code that tells excel to look in column B (PSD ID) and when it finds duplicates sum the values in column S (Gaining Doc Matched Quantity). I know how to do this when it is just those two columns but I would like to be able to consolidate the sheet so that I can keep the data in all the other columns. For my purposes, I don't care which row excel choses to pull data from in regards to the other columns when it is doing this consolidation. All I care about is that Column S and that it is summed. I've attached a sample doc that shows what the data looks like in the beginning and what I would like it to look like in the end. I guess I could do a vlookup function for all my other columns but I figure there has to be a more efficient way. If someone could help with getting the vlookup to work for column A I would appreciate it as well. Thanks in advance for the help.

Consolidation Problem.xlsx