I often get text files of similar type (Tab delimited, CSV, etc.) but they all have a header row. A super easy way to merge the data together is to
- Created a folder that only has the files you want to merge
- create a command prompt in the directory
- use the following dos command to merge the files (adjusting the extension to your purpose: copy *.csv merged.csv
This will merge all of the files ending in .csv into the merged.csv file however it keeps all the header rows. :( This annoyed me so I wrote a short program to use AutoHotkey and only keep the first header row.


