It works by adding spaces, which is good, but it does not concatenate all the cells into one line.
I've attached sample file with original data in A1:A, Your formula applied in B1:B. And sample of what I'm trying to achieve in C1:C
Thanks for helping, hopefully I can get some advice how to modify your original formula.
i'm not sure if my idea is good, but maybe we can then concatenate cells using if statement, till the moment we see a a blank cell now as produced by your formula above
Bookmarks