Read all .csv file in Folder , rearrange and write in one .csv file

I have more than 150 .csv file in one folder all the .csv files are having same number of rows and column "10 rows and 5 columns". as shown below

File 1

P1C1.csv %(File 1)

1	11	21	31	41
2	12	22	32	42
3	13	23	33	43
4	14	24	34	44
5	15	25	35	45
6	16	26	36	46
7	17	27	37	47
8	18	28	38	48
9	19	29	39	49
10	20	30	40	50

File 2

P2C2.csv %(File 2)

51	61	71	81	91
52	62	72	82	92
53	63	73	83	93
54	64	74	84	94
55	65	75	85	95
56	66	76	86	96
57	67	77	87	97
58	68	78	88	98
59	69	79	89	99
60	70	80	90	100

like this above file 150 files are there in single folder.

I need to read all .csv file. Form each csv file i need to read first "8 rows and 5 column" and write it in one single sheet for all 150 files in order (File1, File 2,...,File 150). example is shown below.

Write1.csv

1	11	21	31	41 %(from File 1)
2	12	22	32	42
3	13	23	33	43
4	14	24	34	44
5	15	25	35	45
6	16	26	36	46
7	17	27	37	47
8	18	28	38	48
51	61	71	81	91 %(from File 2)
52	62	72	82	92
53	63	73	83	93
54	64	74	84	94
55	65	75	85	95
56	66	76	86	96
57	67	77	87	97
58	68	78	88	98
...                %(from File 3)...

like this it go for 150 files. And remaining row number 9th and 10th for 5 column of each file is written in another single sheet same as like above example is showen below.

write2.csv

9	19	29	39	49  %(from File 1)
10	20	30	40	50
59	69	79	89	99  %(from File 2)
60	70	80	90	100
...                 %(from File 3...upto File 150)

Please Help me to solve. (THANK YOU)

[Walter Roberson]

Does the order of the files matter? If so then what part of the file name can be used to determine the order?

[Kaviarasu Nataraj]

Yes, Then only i am able to represent First 8 rows from this perticular file and give the number representation (for example P1C1 = 1, P2C2 = 2

                                       % Representation
1	11	21	31	41          1       %(P1C1 = 1)            %(from File 1)
2	12	22	32	42          1
3	13	23	33	43          1
4	14	24	34	44          1
5	15	25	35	45          1
6	16	26	36	46          1
7	17	27	37	47          1
8	18	28	38	48          1
51	61	71	81	91          2       %(P2C2 = 2)          %(from File 2)
52	62	72	82	92          2
53	63	73	83	93          2
54	64	74	84	94          2
55	65	75	85	95          2
56	66	76	86	96          2
57	67	77	87	97          2
58	68	78	88	98          2

from this representation in the seperate file when i do analysis i can able to identify the data.. from the perticular file.

But that representation file is Created in Separate excel file when i used in Machine learning that data will be compared and give the result.

Answer 1

[Stephen23]

P = 'absolute or relative path to where the files are saved';
N = 150;
C1 = cell(1,N);
C2 = cell(1,N);
for k = 1:N
    F = sprintf('P%dC%d.csv',k);
    M = readmatrix(fullfile(P,F));
    C1{k} = M(1:8,:);
    C2{k} = M(9:10,:);
end
M1 = vertcat([C1{:}]);
writematrix(M1,fullfile(P,'write1.csv'))
M2 = vertcat([C2{:}]);
writematrix(M2,fullfile(P,'write2.csv'))

[Walter Roberson]

    F = sprintf('P%dC%d.csv',k);

You need two numeric parameters to format two %d properly.