How to arrange the values of the matrix according to index number?

I have index number of matrix A =[1 3 5 6], B= [ 2 4]. The values corresponding to index number matrix A is A1=[3 4 -7 5; 2 5 10 -9; -11 56 9 -4; 6 -7 4 20] and the values corresponding to index number matrix B is B1=[13 4 -70 51; -1 95 12 -9].

I want to generate a matrix C with index number of A and B after sorting like C=[ 1 2 3 4 5 6] and the values of the matrix C1 will arrange according to the index numb of C.

How will be arranging the values of C1 from A1 and B1 according to the index number C? Please help on this

[madhan ravi]

Can you elaborate? It’s not clear.

[AS]

I have two matrices A1 is 4 by 4 matrix

A1= 3 4 -7 5

2 5 10 -9

-11 56 9 -4

6 -7 4 20

B1 is 4 by 2 matrix

B= 13 -1

4 95

-70 12

51 -9

after some analysis I got the column number of A1 and B1 is like A =[1 3 5 6], B= [ 2 4]

Now I want to creat C matrix with adding A and B cloumn number;

C= [ 1 3 5 6 2 4];

C_new=sort[1 2 3 4 5 6];

Now, I want to store the values from A and B with exact column number of C_new.

Means in C_new, 1 value is column number of A1 matrix so the value will be taking from 1st column of A1 and similarly 2 is is column number of B1 matrix, so 2nd column of B1 matrix value will be stroing.

[madhan ravi]

What? A1 only has 4 columns, what are you talking about?

[AS]

I have got from some analysis that 4 column and 2 clomun i got from another one.

[madhan ravi]

Still not clear, show us explicitly how C_new looks like with numbers?

[AS]

C_new is showing index number only and its va;ue will be

C_value= 4 by 6

3 13 4 -1 -7 5

2 4 5 95 10 -9

-11 -70 56 12 9 -4

6 51 -7 -9 4 20

Final output will 4 by 6 matrix.

I have tried with taking C_value=zeros(4, 6) and then try to store the values from A1 and B1 with their proper index number. But unable to do.

[madhan ravi]

Check my answer below.

Answer 1

[madhan ravi]

C_new = zeros(numel(A), numel([A, B]));
C_new(:, A) = A1;
C_new(:, B) = B1.'

Answer 2

[madhan ravi]

A faster version of the other answer:

C_new = zeros(numel(A), numel([A, B]));
[IX, ix] = sort([A, B]);
C_new(:, IX) = [A1, B1.'];
C_new =  C_new(:, ix)