Hi everyone,
I need help with this request please.
I have a big data set. Sample of it looks like this. Sample file is also attached.
So column A contains merged cells. Is there anyway column B, C and D can be merged based on the merged cells in column A
For example,
A2, A3, and A4 are merged and therefore, only B2, B3 and B4 are merged. Same thing with C and D
A5, A6, and A7 are merged and therefore, only B5, B5 and B7 are merged. Same thing with C and D
merge cells.jpg
I really appreciate your help
Bookmarks