transferring data between two files

[Feras95p]

Dear all,

I have attached two files, what I'm trying to reach is that, I want  when I have these two file as input I want to check the total cash and total number of orders of each mobile phone and write beside the same number phone in file 2 

For example the output should be in file 2 like the highlighted green one with keeping the original data from column A to J and added only the K and L columns 

[deviseetharaman]

Hi @Feras95p 

You can just use a join and union to get the desired the output

[deviseetharaman · Accepted solution]