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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Animal[/TD]
[TD]Pet Name[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Jake[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Karen[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Bruce[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ruby[/TD]
[/TR]
</tbody>[/TABLE]


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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Animal[/TD]
[TD]Pet Name[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Jake
Karen[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Bruce
Anna
Ruby[/TD]
[/TR]
</tbody>[/TABLE]


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!