General Forum

Question about EXCEL, how do you merge 3 columns into 1 column?

Depends on what you want the single column to be and what you want to separate the data coming from the 3 columns.

If the columns are A, B, & C, and you're putting it in Column D - with spaces in between:

=A1&" "&B1&" "&C1

=Column1&"-"&Column2&"-"&Column3

Feel free to replace the hyphens with spaces or whatever you want between the column contents

You need to use a "Helper" column.  For instance, if you want to merge A, B, C, you insert an empty column D.  Then, at the top row, you create a merge formula in D1:

=A1&B1&C1  (There are other formats if you want to insert a space, etc,- see https://www.howtogeek.com/782211/how-to-merge-two-columns-in-microsoft-excel/

Then copy that forumla down to every row.

Then you  insert another new column E, copy the entire column D, and use "paste spevial / values" into a new column E.  Then you can delete all the original columns A-C and helper column D and all th values from the prior A-C will be in column A.  

thanks everyone, now I try the suggestions

excellent you are fantastic, I solved my problem, thanks