The assistance I have previously received in this Forum has been excellent.
I am thanking you in advance for any assistance regarding the following issue.

I have a column consisting of predictable data categories such as the following:

Column "A"
aaaa
bbbb
cccc
dddd
eeee

Unfortunately, the data is available to me with an unknown number of blank rows separating them such as:

Column "A"
"aaaa"


"bbbb"
"cccc"

"dddd"




"eeee"

The number of blank rows is inconsistent from one source to the next. I would like a procedure that will eliminate any blank rows between the values "aaaa" through "eeee". In addition, the nature of the beast is such that filter sorting is not an option.