I need to combine a bunch of excel files into one master excel file. Your job would be to use any statistical program (ideally either just excel or stata or spss) to combine the data in the excel file sheets into one master combined excel file.
I am attaching a sample file called Combined... This file is a sample of the original excel file.
I am attaching the master file, with the subheadings, and two rows example.
Slideshow is SS1 named on the file.
All of the processes will have to be automated.
Your job would be to write an algorithm to do this.
We only have 5 files so far, but anticipate 20 files total over the next year.
Therefore, would like an automated process rather than someone manually doing it.
So I have received many proposals.
However, I need to emphasize again that I need the code and I need everything automated, with very minimal manual labor.
to confirm that you can do this, if possible, please do this for a few sheets on the one excel file I provided, and put it in the master file.
I just want to make sure the format is correct, and you understood everything.