How to efficiently merge cells in Excel

[Margot Vanlaet]

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!!

 

[Margot Vanlaet]

This is what the file should look like

 

[Kerryx]

can you provide some data to work with using XL2BB

 

[Margot Vanlaet]

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!!

can you provide some data to work with using XL2BB

I am trying but it doesn't want to work on Mac

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to efficiently merge cells using a macro?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.