How to efficiently merge cells using a macro?

Hi everyone,

I am trying to develop an index, but in order to make correct calculations and pivot tables, I need to merge some cells. Doing this manually would take a lot of time, therefore I am looking for a more efficient way. I assume a Macro might help me out here, yet I do not really know how to get started.

A bit of context on the datasheet: The info in cells E until AB was used to calculate the numbers in cells AC, AD, AE and AF. This information was hided as these cells do not need to be merged.

I am in the need of a macro that:
- Merges the value in column A when the organization name is identical.
- Merges the information in columns AC, AD, AE and AF when it refers to the same organization in column A.

Can somebody help me out? Thank you in advance for the help!!

Before
Screenshot 2022-08-25 at 11.29.31.png

After
Screenshot 2022-08-25 at 11.48.40.png


crossposted on mrexcel