How to merge repeated data cell in Excel?

I have excel data containing in column A "Plot number" which is repeated and other four column is land area and the next column is "Land Owner Name". Now I want to merge same plot no if the land area is same if differ then I want to leave as it is. And another thing I want to do that the all land owner name is merge in a row. Please help. Your suggestion is highly appreciated.

Indra

This macro will convert your table into a consolidated version.

Please Login or Register  to view this content.

============
How to use the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

This macro is designed without the BEFORE row, so it expects your titles to be in row 1 and your first row of data in row 2, plot numbers in column A. Sample attached.

thanksss !

Thanks for your code JBeaucaire. But I steel want to do one thing that the differ land area in a same plot no. will be no change or want to keep all plot no and another one column is Address. If it contains same address then I want to keep only one address, if differ each other then merge all address of same plot no. Please see attachment. Thanks

Indra

Try this, had to use a columns H:J for helpers, but it should work for you.

Please Login or Register  to view this content.

Thanks alot JBeaucaire. You are great. It is working very nice to me. If you don't mind, can I asked another one question in this regard? How can I highlight entire row all repeated plot no? Your guidance and suggestion is highly appreciated.

Please post a sample.

Hello JBeaucaire, I got the solution. I modified your code. It's working fine. Thanks

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)