Hello Everyone! I have two excel files with the same column names but arranged differently and also number of columns are different in both excel files like E-form No. in the first excel file is second column and in the second file is fourth column.
First Excel file has 19 columns
Second excel file has 26 columns
Solution Required
I wanted to write all my data in first excel file(having 19 columns), according to the columns present in first excel file, I don’t want any column from second file which is not present in first excel file.
I tried using JOIN TABLE but then is realized values in columns are also different LOL…
I just wanted to append the range of second file into the first one according to the columns in first file. Thank you