Surely, many times had to combine combine multiple CSV files with same structures but different data and have resorted to simple but tedious ETL process such as multiple data inputs on Kettle or similars. We’ll leave here a very simple trick, with a simple command, we could merge as many CSV files as you want.
Copy in a folder all csv files as you want to merge. Go to console, with administrator role, go to folder. Then type
copy *.csv merge_csv.csv
It will automatically create a file, merge_csv.csv, as a result from the merge of many files included in our folder.