I was trying to import data into Excel the other day, when I noticed that Excel only allows me to import 1 text file at a time. Because I’m too lazy to import them 1 by 1, I found this command line on how to combine data from multiple text files into a single file 😀

Lets say you have four text files a.txt, b.txt, c.txt and d.txt and you want to merge the contents of all the text files into one target.txt. To merge text files open the MS DOS command prompt and change the directory to where all files are stored. Now issue command : copy *.txt target.txt

This will merge all the text files in the directory and create a new file named target.txt

Source: http://www.thetechhub.com/2010/04/combine-text-files-into-one-with-single.html