Forum Discussion
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 in cell C1 John Jones, that's what I mean by horizontal merging.
In my Case the A column contains dates, and the B column contains what happened on that date.
eg.
A1 May 1963
B1 The Beatles had their first no. 1 single
The output I want in the C column is, something like this
May 1963
The Beatles had their first no. 1 single
So the date in Column A goes above the data in Column B
which is what I mean by vertical merging.
Can it be done?
=A1&CHAR(10)&B1This formula returns the intended result in my sample file. Wrap text must be activated.
2 Replies
=A1&CHAR(10)&B1This formula returns the intended result in my sample file. Wrap text must be activated.
Perfect, many thanks
