Excel Macro for Adjacent Cell Merging
Budget: $30 – $250 USD
Just a quick bit of help needed in excel macro writing.
See attached before and after showing a piece of the original data. and what i neeed the macro to achieve.
WHAT IM ASKING
If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png.
I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency.
Essential skills and experience should include:
- Expert knowledge of Excel and its macro functionality
- Prior experience with data manipulation tasks such as merging cells
- Understanding the rules or criteria for merging specifically adjacent cells
- Excellent problem-solving skills and attention to detail
I will provide the working data sheets and a detailed explanation of the rules for adjacency-based merging to guide the creation of the macro. Any prior work regarding Excel macros for similar data manipulation tasks will be highly regarded.
See attached before and after showing a piece of the original data. and what i neeed the macro to achieve.
WHAT IM ASKING
If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png.
I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency.
Essential skills and experience should include:
- Expert knowledge of Excel and its macro functionality
- Prior experience with data manipulation tasks such as merging cells
- Understanding the rules or criteria for merging specifically adjacent cells
- Excellent problem-solving skills and attention to detail
I will provide the working data sheets and a detailed explanation of the rules for adjacency-based merging to guide the creation of the macro. Any prior work regarding Excel macros for similar data manipulation tasks will be highly regarded.