Automatic Excel Script
- by Thomas
I am a 6th year medical student and I'm working on my thesis.
I have no experience with programming whatsoever, a friend recommended me to post my question here. I am strugling with the following problem:
I have data of 400 patients, stored in 400 different excel files.
Each file contains 34 columns in a specific order, let's say A to Z.
The order is the same in each of these 400 files.
Now I need to a make a new excel document that contains the first column of each patient.
So I need all the first columns of my 400 different excel files, lined up next to each other in a new document. Preferebally in the form of a automatic script.
After that I want to do the exact same thing but for the second column, then the third and so on.
This is probably a problem that has already been solved. Otherwise could someone help me out?
You have my thanks!