Quote:
Originally Posted by Dave Schwartz
1. Open Target File. (i.e. file you want to put the 100 races into)
2. For each Source file...
3. For each record in the source file...
4. Write that record to the target file.
OR...
If the files are just csv's...
Create a new file using a batch file and append each file to the target file. This would be amazingly fast.
|
Thanks, Dave.
I have written a program that will do the bottom half of your reply -- appending each file onto the end of the previous file to create a 10 column x 100 row file.
What I want to do is append each file in a sideways manner so that the 10 column x 100 row file becomes a 100 column x 100 row file.
You're right that I could read each row of the source file and each row of the target file and then append the source file to the right most column of the target file. I was hoping there was some software or an excel macro that would do this.
Right now, I open the target file into excel. Then I open each source file one at a time and copy and paste the data into the first row, 11th cell of the target file. Then repeat at the 21st cell, etc.
It is soooo sloooow to do it manually -- especially if I have to do it several times when the files change.