How do i joine many tables that exist in excel files using matlab?

Dear experiences..

i have many excel files that stored in D:\table directory, all excel files involves unique headers ( file name , label) and look like the following:

file name         label
steer-20-30         1
agilty-come-tone    2
reed-20-20-3        1
etc..

in all files, file name column is unique also but in every file its come in different orders than others based on label values, i need to join all these files to be in general table.. look like the following:

file name        label1_(max value in label field=2)  label2_(max value in label field=4)....
steer-20-30         1                                          3
agilty-come-tone    2                                          4
reed-20-20-3        1                                          2
etc..

where:

label1 field its come from excel file1, label2 field comes from excel file2, label3 field comes from excel file3...etc, labels columns perhabs comes with (label) header and concatenated with max values in every label columns .. example (label_2), (label_4), ...etc. example of two tables...

thanks for any help.

Answer 1

[MathReallyWorks]

Hello Ahmed,

Why this question again?

For other people, who have visited here for first time:

Check out Guillaume's solution on a similar question: how do i combine multible excel file into single file using matlab?

[ahmed obaid]

thanks, for your comments, in my previous question i need to combine files without joining property... here join among tables must be perfomed on columns .. there based on whatever data exist , thanks