I have a macro that pulls data from a web table. The colums used are A-H.
When importing some of the text in colum F is spread to mutipal rows. What I
would like to do is go down column D till something is foound. If found,
search the next row down to see if it is blank. If blank then add the
contents from that row in column F to the one above then delete the row. Then
on to the next row and till the end.

Thanks
Bob