I must start by saying thank you for any help as this is my first post and it's been about 8 years since I have tried my hand at any programming.

I have a report that is output from our MRP system into excel. I have already written a macro to reformat the original report into something somewhat usable, now I need help taking it to the next level.

As you can see in the attached file, on sheet "Original," the report will list a part number and description only in the first row while additional quantities are somtimes present below the first row. What I would like to do is for each part number to only have one row displaying the total quantity. I would then like to delete the rows with an underlined heading along with any blank rows. And finally, I would like to sort from highest quantity to lowest.

The final product show look something like the sheet "final" in the attachment.

Test Example.xlsx