Add duplicate part qty's in a data table

Hi I'm after how to do a macro that will search for duplicated part numbers in a table and merge them into 1 line.

Basically going from this:

Please Login or Register  to view this content.

To This:

Please Login or Register  to view this content.

Someone suggested using a pivot table but I don't know if this will do what I wanted and the thread was locked before I could ask....

Thanks. Matt.

Matt

A pivot table will give you the result you are chasing, with the exception that the code will only be shown once per code block.

Did you try to make the pivot table work?


rylo

sort of didn't try fully as it didn't look like what I wanted, don't want drop down lists or things like that, just wanted to be able to consolidate the duplicated lines. Will give it a go tonight and post back....