Combining semi-duplicated records (with different columns)?

[efjim]

How would I combine records if specified columns are the same?

Here's what I have, and the result I'm looking for:
rAzg8.png

I'm not sure if it's possible with built-in function such as merge or this requires VBA -- I searched on google but couldn't find the same problem. Any recommended direction would be appreciated.

[oeldere]

you get better help on your question if you add a small excel file, without confidential information.

please also add the expected result manualy in the file.

[walruseggman]

Change the ws1 name on the first line of code to match you actual sheet name.

Also assumes data starts in column A.

Please Login or Register  to view this content.

[efjim]

This is beautiful, thank you !!!

[walruseggman]

You're welcome. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

And any reputation points (the star in the lower left of the posts) are appreciated.