I have CSV files which are in a form of:
1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9
.....
up to 18.csv
.
I want the result in result.csv
to be:
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9
I tried cat
but it appends one another after only. I also want to transpose the CSV such that 1.csv
is converted to:
1
2
3
4
5
6
7
8