Copy all CSV files you wish to merge into same directory ie “c:\temp\csvfiles”
Powershell Code to merge files:
Get-ChildItem -Path c:\temp\csvfles -Filter *.csv | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv .\combinedcsvs.csv -NoTypeInformation -Append