Merge cells in a table based on number of common values

[saidineshbabu]

Hi,

I wanted to merge part of the table which has the cells with common values.

Attached the sheet with original and proposed table.

Pls help me in getting this through macro.merge doubt.xlsx

Thanks in advance.

[AB33]

I do not recommend to merge cells, but your choice.

[saidineshbabu]

Thanks for the response. This works fine with the given example. I need to do this with 1000 rows table and the data keeps changing. Can you please help me for a dynamic sheet?

Also, the reason for merging is to copy the whole table and paste it in word to send as a report.

Thanks.

[AB33]

I do not know how the dynamic sheet looks like. Could you post it?

[saidineshbabu]

The number of rows and data might change. attached another sample. There will be 1000+ rows like this.
dynamic sheet.xlsx

[AB33]

Try this:-

[saidineshbabu]

you are rocking expert.

[saidineshbabu]

I have a requirement which I missed in my previous ask. Since it is complex I am not able to try it myself. Need expert's help.
Here if the Measurement is "Height", the corresponding ID1 and ID2 should be deleted. Basically the output should have only IDs of Weight and Breadth.

Attached the excel. Need macro to automate this.

Thanks in advance.

[jindon]

Do not recommend to use "merge" as a procedure name since it is a vba reserved word.

Try the attached

[jindon]

If the code solved your problem, mark this thread as "Solved", as well as http://www.excelforum.com/excel-prog...r-columns.html

[saidineshbabu]

Thanks. This works partially. If it merges the rest of the columns "Height", "Weight", "Breadth" and "Total", that would be awesome.

[saidineshbabu]

sure will do. How to mark it as solved?

[alansidman]

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

[jindon]

I've never done it, but if you go to your 1st post and [Edit], you should see the option. I guess.

Change to

Please Login or Register  to view this content.

[saidineshbabu]

Hi Jindon,

I am sorry that I am bugging you with more questions/requirements. Just realized that I missed to ask about handling "Height" Column in output table.
Attached the spreadsheet with requirement (eg. Peter). Pls help. Thanks in advance.

[jindon]

You need to explain why your result includes A24 /B24 for "Sebastian".

This doesn't include that line in the result.

Please Login or Register  to view this content.

[saidineshbabu]

A24 /B24 for "Sebastian" was included by mistake.

Your code solved by problem. Thanks expert.