I need help finding a macro that can merge cells across rows in a column if those same rows are already merged in another column. Below is a screenshot of what I have now that shows the cells that are merged in Column A
.
The below screenshot is what I need the spreadsheet to look like after the macro runs; the corresponding cells in Column B
are merged.
Best Answer
This was the shortest I could make. I tried it with your example and it worked for me.