combine/merge row cells text between blank rows

[wapo]

Wondering if someone could help with the following problem. I have a large list of text in one column which i need to combine between blank rows into one cell or a new column, the number of rows to be combined varies. for example

aa
bb

ww
xx
zz

rr

gg
hh
ii
jj


would become

aa bb
ww xx zz
rr
gg hh ii jj

I have over 30000 lines so doing it by hand is not an option.
Thanks for any help or suggestions.

 

[hiker95]

waterL,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.