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.
- Thank You!!! Both of these work great. After some experimenting with your instructions, I found that FlashFill is great for 2 columns only where they are right next to each other. Concatenate with Paste set to Values Only works if need more than two columns or if the data columns are not right next to each other. Thank you, this will save me hours of typing!
