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.
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.