Forum Discussion
Solved
Combining Data from two columns into one column
Happy New Year with what should be a simple problem. Column A Column B Column C Mr. Smith Mr. Smith Mr. Jones Mr. Jones I have two columns, Ti...
This can be done with flashfill. Enter manually "Mr. Smith", "Mr. Jones" in cells C1:C2 and then press ctrl+E. This returns the result shown in attached file.
=CONCATENATE(A1&" "&B1)
This works as well if you copy the results of the formula and then paste only values.
After either option you can delete column A and B.
This can be done with flashfill. Enter manually "Mr. Smith", "Mr. Jones" in cells C1:C2 and then press ctrl+E. This returns the result shown in attached file.
=CONCATENATE(A1&" "&B1)
This works as well if you copy the results of the formula and then paste only values.
After either option you can delete column A and B.