transfer the formation the data in excel as a formation of matrix

Dear all,

Hello. I have to convert it to matrix form using matlab now.

The default result is A through F. So A needs to be replaced by the x axis and B by the y axis.

The vertical red border of C should be replaced by the horizontal border on the right, followed by the vertical red on the second row horizontally. Green, blue, and purple are different variables, so they have to be located somewhere else. This should continue and eventually change to a 2.5x2.5 matrix ... I need help.

Answer 1

[Bhargavi Maganuru]

You can refer xlsread and readtable to create matrix and table respectively from the excel files