MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining or merging 2 columns

Posted by SAM GORDON on February 12, 2002 11:03 AM

Is there a command (Not using Macros or a DataSort) to combine or merge 2 columns with data in different cells of each column without losing any of the data ?
For example: if I have data in cells A1, A4, A6 and in cells B2, B5, and B7, is there a command or group of keysteps so that the combined data is in cells A1, A2, A4, A5,A6, A7 ?

Sam Gordon

Posted by Skrappy on February 12, 2002 11:13 AM

You can use the formula of =Concatenate(#,#) or similarly =# to combine the values of any two columns. You can tweak these funcations quite a bit to fix your problem.