First time poster I'm afraid!
I'm looking to concatenate a number of cells of text together, the number of cells is variable and always followed by a blank cell - e.g.
A B C
item 1 text 1
text 2
text 3
item 2 text 1
text 2
item 3 text 1
etc.
I'd like to concentate text 1,2,3 for each item into a cell in C - any thoughts?
Bookmarks