Forum Discussion
Solved
Merging two Columns Vertically, not Horizontally
I wish to merge two columns. However, all suggestions I have found so far use horizontal merging, often using the Concatenate command, so cell A1 contains John, and cell B1 contains Jones, producing ...
=A1&CHAR(10)&B1This formula returns the intended result in my sample file. Wrap text must be activated.
=A1&CHAR(10)&B1This formula returns the intended result in my sample file. Wrap text must be activated.
Perfect, many thanks