join blank rows
 

Hello,
I am trying to merge ~10000 rows of data. I used to use the JoinRows()
macro from www.mvps.org/dmcritchie/excel/join.htm
But having to do this again and again, I was wondering if someone knew
how to automate.

The rows are to be merged only if the column A is blank.

test |22
|22
|22
_____________
form |333
|333
_____________
ad |223
|223

Any help would be greatly appreciated.
Thanks
Farron