Merge multiple groups of adjacent cells, which are separated by a blank cell, into respective single cells.

[NateZona]

Dear fine people of Mr. Excel,

I am not sure if this has a possible solution, but here is my problem...

I have a pdf with a large list of hyperlinks which have a text description attached to them. I tried many different ways of copy and paste to get them formatted correctly in excel to no avail.
However, I was able to separate them into groups of cells with a blank cell in between. Some groups are three cells, some are two cells.

Here is an example of what I mean...

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Data1a[/TD]
[/TR]
[TR]
[TD]Data1b[/TD]
[/TR]
[TR]
[TD]Data1c[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Data2a[/TD]
[/TR]
[TR]
[TD]Data2b[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Data3a[/TD]
[/TR]
[TR]
[TD]Data3b[/TD]
[/TR]
[TR]
[TD]Data3c[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Data4a[/TD]
[/TR]
[TR]
[TD]Data4b[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Data5a[/TD]
[/TR]
[TR]
[TD]Data5b[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Data6a[/TD]
[/TR]
[TR]
[TD]Data6b[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I would like to do is be able to combine each group into one cell respectively (i.e., "Data1a-c" in one cell, and "Data2a-b" in one cell, etc) using a macro on the whole sheet.


I have so many of these groups that it will take far too long to manually combine them one by one.

Thank you for your time, and I hope to hear from you soon!

Warm Regards,
Nate Zona

 

[NateZona]

I'm sorry for the confusion, as Reply#6 is not actually my data but a quote from Peter_SSs's post above!

 

[hiker95]

I'm sorry for the confusion, as Reply#6 is not actually my data but a quote from Peter_SSs's post above!

NateZona,

What cell contains Data1a?

And, what resulting cell should contain Data1a, Data1b, Data1c?