Hello, I have 800 files with 1554rows and 2columns so (1554×2) , that I'd like to read from a folder and then combine them into a large matrix of 1554×801. The first column is common to each file, and so I'd like to set only the first column in the final matrix as the same column of all the files, and then the subsequent columns as the second column of each of the 800 files. I hope this makes sense.
Example:
A.csv=[1 2; 4 5] and B.csv=[1 8 ;4 7], C.csv=[1 6;4 10]
I'd like to combine these into
Combined=[1 2 8 6; 4 5 7 10]
Would anyone possibly have a code for this? I'm new to Matlab and have tried a number of codes that merge files. but they stack them horizontally so I get
[1 2;4 5;1 8;4 7;1 6;4 10].
Thank you!
Best Answer