I have a set of data that has a blank in every other row. Is there a way to
remove these blanks ? I tried the paste special but to no avail.

Thank you in advance.

Carl