Home > Mobile >  merge many csv files into one csv file
merge many csv files into one csv file

Time:09-14

I have 15 CSV files that I must merge into one, I was trying to copy from the windows command but this joins it in a single column, what I am looking for is that each CSV is a column within the merged file.

D1.csv   D2.csv   D3.csv
11       21       31
12       22       32
13       23       33

then

Copy *.csv combined.csv

Result

11
12
13
21
22
23
31
32
33

desired result

11 21 31
12 22 32
13 23 33

CodePudding user response:

@ECHO OFF
SETLOCAL enabledelayedexpansion
SET "sourcedir=c:\testso\sourcedir"
SET "destdir=c:\testso\destdir"
SET "outfile=           
  • Related