Hi to everyone,

I've two different files, one with almost 3000 lines and another one with 6700. These two file has different columns data as well.

What I've to do is to associate for each line of first file the related line of the second file where the common data is a day

Just to explain better, I'm talking about microbiological samples, collected the day X, in the zone Y (both on same line) and -for 2nd file- the related results (name of "detected bacteria species") in column Z and the referral collected day in column K (both on same line).

In the same day there are different collected samples, in different zones. For each samples is possible to have more results (that's why 3000 lines vs 6700).

I need to associate the content of the different columns (e. g. X and Y) and same line of the first file, matched with the related columns (e. g. Z and K) same line, of the second file.

Mission impossible?

Thank you for helping me anyway!