Hi,
I am trying to combine vertical cells of content in a Column (varying lengths of text and numbers) into one cell next to it and to stop at a blank row and start the combining process again from the content in the next available cell after the blank row until it gets to a blank row and then starts again. I have attached the example below to an excel attachment for ease of viewing. Vertical cell test.xlsxFor example:
Column 1 Column 2
Joe90 Joe90Alf45Bob354
Alf45
Bob354
Blank Row
Brydgf Brydgftest25excel3w4e
test25
excel3w4e
Blank Row
7fr6 7fr6fgrtds7wif7ww
fgrtds
7wif7ww
Blank Row
Many thanks
Bookmarks