Hi everyone,

I imported over 250 excel files and appended them all together to 1 dta file, by using this code:


clear all
ssc install xls2dta
xls2dta, save("/Users/abc/DATA/SRRPT") : import excel "/Users/abc/DATA/SRRPT"

xls2dta, save ("/Users/abc/DATA/SRRPT/SRRPT2.dta") : append, force
use SRRPT2
However, now I am facing the problem that the variables I want to use are not in the same column in the excel files. For example: the variable -Price per Share- is in Column E in some excel files, while it is in Column F in other excel files. Is there a possibility to get them all in the same column?

Thank you so much.