Reference merged cells to concatenate all values in the adjacent rows

[phonesdontfly]

Hello!

I have a larger data set that has merged cells in column A (see example below).

Pretend that in column A ("Animal") that lines 2 and 3 are merged, and that lines 4,5,6 are merged. Nothing in column B is merged. the interface isn't allowing me to merge anything here.

column A // Column B

Animal	Pet Name
Dog	Jake
	Karen
Cat	Bruce
	Anna
	Ruby

<tbody>
</tbody>

What I would like to do, is have a macro identify which cells are merged, and then concatenate (using line breaks) and merge the cells in the column immediately to the right, such that it looks like this after:

column A // Column B

Animal	Pet Name
Dog	Jake Karen
Cat	Bruce Anna Ruby

<tbody>
</tbody>

I hope this makes sense! Thank you all so much!

 

[phonesdontfly]

I can't figure out how to mark this thread as solved- I found an a solution on another thread. Mods, can you please mark this as complete and/or remove it? Thanks!

 

[HarrisQ]

I can't figure out how to mark this thread as solved- I found an a solution on another thread. Mods, can you please mark this as complete and/or remove it? Thanks!

You could have included the link to the found solution!