Merge/Combine 2 Rows

You may try this code to achieve this. Click on the Green Button on the sheet to get the desired output.

Please Login or Register  to view this content.

Please find the attached to see if this is what you are trying to achieve?

Nothing actually if your first column (65 GAL RECYCLE CART SER NO) in your original workbook is as same as in your sample sheet. Because the code is based on the first column.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

**Also edit your profile to add location and current Ms-Excel version being used.

The code is in module1. Open VBA editor (Alt+F11) --> Double click Module1 to see the code.
The code is as follows.....

Please Login or Register  to view this content.