Hi guys,
Thanks for helping,
I have text in excel rows in the following format
(empty cell)
(empty cell)
text
text
text
text
(empty cell)
(empty cell)
text
text
text
(empty cell)
(empty cell)
text
text
text
I want to combine all the text between two empty cells together i.e combine all rows between empty cells into one cell. The only issue is that the number of rows between empty cells is not the same as you can see in the above example where it might be 4 rows before the next empty cell or 5 or 10 etc.
Any help?
Thanks so much!
Bookmarks