I want to create a file that contains columns from two input files. File1 is like:
aa 32 bb 15 cc 78
fa 19 bc 23 cc 50 de 28 aa 45 bb 31
The task is, read through File1, if the 1st field of a row exists among the 1st field of File2, then print that line of File2, with both columns and add the 2nd column entry of File1 containing the 1st field.
The output should be like:
aa 45 32 bb 31 15 cc 50 78
awk is preferred for the script.