Hi all I want to merge to columns in excel 2003.
Col1 Col2 ------------ 1 5 3 4 4 6 7 6
The merged column should look like this:
Col3 ---- 1 3 4 4 5 6 6 7
Assuming, that your Col1, Col2 and Col3 are Columns A, B and C, you can use makro:
Range("A1:" & Range("A65536").End(xlUp).Address).Select Selection.Copy Range("C1").Select ActiveSheet.Paste Range("B1:" & Range("B65536").End(xlUp).Address).Offset(1, 0).Select Selection.Copy Range("C65536").End(xlUp).Select ActiveSheet.Paste
Although you could easily use Excel’s built-in functions to copy and paste the values from each column into the third column, you don’t state if it’s a requirement that the results in Col3 need to be sorted, or whether duplicate values should be removed or not. If so, you might have to write a user-defined function (equivalent to an Excel macro) in Excel VBA to do this.
Your solution might look like this (pseudo-code):
- Iterate through all rows in Col1 and store values in an array
- Iterate through all rows in Col2 and store values in a second array
- Create a new array and combine the values from the other two arrays
- Output the values from the combined array into Col3
Your function/macro will probably need to accept three input parameters which would be the ranges of the two source columns and the output column.