Appending excel data into another excel when fields are not same

excel

#1

Hi All,

I have as below:
I have an excel with the column(as A, B, C, D), I want to append that data into another excel which has header as (A,xyz,B,ghjt,C,D,ffs,A).

I want to copy data of Input file to output file but as per the field. as A field data should copy to A, B Field data should copy to B in output file:

input File:
A B C D
1 2 3 4
1 2 3 4
1 2 3 4
1 2 3 4

Output File:
A xyz B ghjt C D ffs A
1 2 3 4 1
1 2 3 4 1
1 2 3 4 1
1 2 3 4 1


#2

Hi, Having the same issue and did not find any solution. Any help highly appreciated.