Rearrange matrix and combination issues

I have 10 matrix(1x7) (Ei, i=1:10) like this

Firstly, I want to combine to make a new matrix with 2 column [E1,E2] [E1,E3] ... [E1,E10]

and then arrange it into 1 matrix like the image below.

How can I make a loop for this problem?

Thanks

[madhan ravi]

upload your data as a text file

[Dai Tran]

Here is my data. Thanks

[madhan ravi]

The datas are hard to interpret , is there any other formation of your data?

[Dai Tran]

Actually the above data I want to change for enhancing the training data set for ANFIS.

Because these expose factor is multivariate data, so I want to change the relation between it to make a better result.

That's what I trully want.

The following image come from only 1 relationship.

[madhan ravi]

Does this do the job?

a=reshape([T(:,1) T(:,3)],7,[]);
a=a(:); 
desired=[repmat(a(1:7),9,1) a(8:end)]

[Dai Tran]

Thank you for your help.

it's really useful.

Answer 1

[KALYAN ACHARJYA]

col1=xlsread('text.xlsx','B:B');
col2=xlsread('text.xlsx','D:D');
new_text=[col1 col2];
xlswrite('new_text',new_text);

[madhan ravi]

The OP wants to match E1 with all the E's

[Dai Tran]

Sorry, but I want more than that.

I want to create the function to automatically match and combine the matrix like what I present above.

Thanks for your time.