Quote:
Originally Posted by highnote
No. Let's say I have ten files already made and each one is 10 columns by 100 rows. I want to join all ten files together into one file that is 100 columns by 100 rows.
I do NOT want to join them together to make one file that is 10 columns by 1,000 rows.
Each column has a unique name.
I was hoping there was an easy way to join them together using Excel that did not require cutting and pasting.
Now that I think about it, I could probably join them together in Access since each column is unique.
I don't like Access because it is such a clunky program. Just opening it is a nuisance.
|
Simply execute the following command lines:
You can pass all the file names to merge:
Code:
paste -d, file1.csv file2.csv > merged.csv
Or if they are following the same mask do this:
Code:
ls file* | xargs paste -d, > merged.csv