Merging two different column into 1 final column

[Jackcell]

Hi all,
Been searching online for a solution but to no avail.

Problem:
I have 2 different excel files, excel A and excel B.
Excel A has age time money
Excel B has age time date

I need to combine these two columns of both file to be the same, age time date money.

Cheers,
Jack

 

[yosegmail]

just copy the column in Excel A to column in Excel B

 

[Jackcell]

just copy the column in Excel A to column in Excel B

Yes but I need to merge the two files together. Thus I need the data to move from the 3rd column to the 4th column etc

 

[Youngdand]

If age or time is unique, you can just do a straight forward vlookup, by naming the range in one sheet, and using vlookup to look for a value in one sheet and return the value in the column in the named range. the value you want to look up should be the first column in the named range. eg =vlookup(a2,namedrange,column you want to return,false)

Assuming, that neither age nor time are unique identifiers, but a combination of the 2 may be,

In one book, create a helper column at the start of the data, by using =concatenate(age,time) where age and time are the columns you want to concatenate.
Copy this down so all your data now has this unique identifier, and select all you data and name the range.

in the other workbook, in the cell you want your data to appear type =vlookup(concatenate(age,time),range name,1,false) where age and time are the columns on the current sheet, range name is the name you gave in the other sheet, and 1 is the column number of the named range where the value you want to return is.


Regards,

Dan.