Get-ChildItem -Filter *.csv -Path C:ScriptsCSVFiles | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv C:ScriptsCSVFilesCombinedFile.csv -NoTypeInformation -Append
1 Get-Content *.csv| Add-Content output.csv