How to Combine data from 2 columns into 1 column ?
Combine data with the Ampersand symbol (&)
Select the cell where you want to put the combined data.
Type = and select the first cell you want to combine.
Type & and use quotation marks with a space enclosed.
Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2
In the above example there is no gap between the inverted comma ( "") hence the merged cell has no gap between the characters. If you want to show any gap between the characters the increase the Gap between the inverted commas (" ") :