hi, hope all is good
I am given the following, all in a single cell:
aaa
bbb
ccc
ddd
eee
fff
zzz
eee
eee
can someone help with a macro where if I select the entire column, it would split each cell by the blank row into consecutive columns?
aaa ddd zzz
bbb eee eee
ccc fff eee
Much appreciated!
I am given the following, all in a single cell:
aaa
bbb
ccc
ddd
eee
fff
zzz
eee
eee
can someone help with a macro where if I select the entire column, it would split each cell by the blank row into consecutive columns?
aaa ddd zzz
bbb eee eee
ccc fff eee
Much appreciated!