Fine tune script with conditional auto-merging

Hi

First of all thank you for all the help I already received on past posts.

In attachment you'll find a workbook with 2 sheets. The sheet containing the red area is representing the data I have. The sheet containing the green area is what it should become.

I already tried to solve the problem by using Pivot tables but that didn't work out.

I would prefer a script doing this as I already have a macro to get the initial data, and then I would be able to combine both into one.

Thanks in advance for your help.

Regards,
Tino XXL

Originally Posted by royUK

It's a really bad idea to merge cells, merged cells tend to cause problems

Hi RoyUK,

I know merging cells means nothing but sh!t. Can you provide me with an other solution which provides me with the same data?

regards
Tino XXL