Fetching data from another column

I have 2 data as below

A={
     'Genes'      'T0&T2'    'T1&T3'    'T2&T4'    'T3&T5'    'T4&T6'
      'YAR029W'    'dd'       'uu'       'dd'       'uu'       'du'   
      'YBL095W'    'du'       'ud'       'ud'       'du'       'du'   
      'YBL111C'    'uu'       'uu'       'ud'       'ud'       'du'   
      'YBL113C'    'uu'       'uu'       'uu'       'ud'       'ud'   
      'YBR096W'    'uu'       'uu'       'ud'       'ud'       'dd'   
      'YBR138C'    'ud'       'ud'       'ud'       'du'       'du' } 

B={

'Genes'    'T0&T2'   'T1&T3'    'T2&T4'  'T3&T5'   'T4&T6'
'YAR029W'    'd'       'u'       'd'       'u'       'd'   
'YBL095W'    'd'       'u'       'u'       'd'       'd'   
'YBL111C'    'u'       'u'       'u'       'u'       'd'   
'YBL113C'    'u'       'u'       'u'       'u'       'u'   
'YBR096W'    'u'       'u'       'u'       'u'       'd'   
'YBR138C'    'u'       'u'       'u'       'd'       'd'   }

i want to fetch the value from B as compared to A as

gene1(or any variable)=

'Genes'    'T0&T2'     'T1&T3'    'T2&T4'    'T3&T5'   'T4&T6'
'YAR029W'    'd'        'u'        'd'        'u'         'd'
'YBL095W'    'du'       'ud'       'ud'       'du'       'du'   
'YBL111C'    'uu'       'uu'       'ud'       'ud'       'du'   
'YBL113C'    'uu'       'uu'       'uu'       'ud'       'ud'   
'YBR096W'    'uu'       'uu'       'ud'       'ud'       'dd'   
'YBR138C'    'ud'       'ud'       'ud'       'du'       'du'

gene2(or any variable)=

'Genes'    'T0&T2'    'T1&T3'    'T2&T4'   'T3&T5'    'T4&T6'
'YBL095W'    'd'        'u'         'u'        'd'       'd' 
'YBL111C'    'uu'       'uu'       'ud'       'ud'       'du'   
'YBL113C'    'uu'       'uu'       'uu'       'ud'       'ud'   
'YBR096W'    'uu'       'uu'       'ud'       'ud'       'dd'   
'YBR138C'    'ud'       'ud'       'ud'       'du'       'du'

as lile this i need to do for all genes in variable B please help

[Walter Roberson]

What is the pattern for "fetch the value from B as compared to A" ?

[Pat]

Walter a small mistake fetch value from A compared to B

Bis the first matrix so only i have written like that .sorry for for english

[Azzi Abdelmalek]

can you explain?

[Pat]

B is first matrix so have to take genes from there

'YAR029W'    'd'       'u'       'd'       'u'       'd'

from A i have to fetch the other colums below 'YAR029W'

'YBL095W'    'du'       'ud'       'ud'       'du'       'du'   
'YBL111C'    'uu'       'uu'       'ud'       'ud'       'du'   
'YBL113C'    'uu'       'uu'       'uu'       'ud'       'ud'   
'YBR096W'    'uu'       'uu'       'ud'       'ud'       'dd'   
'YBR138C'    'ud'       'ud'       'ud'       'du'       'du'

and combine both as stated above in my post ,please help

like these i want to do all genes in B please help

[Walter Roberson]

http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F

[Pat]

I saw that link walter but could not proceed with my problem,is it possible to use ismember function

[Walter Roberson]

ismember() will not help you with your difficulty of wanting to create variable names dynamically, wanting to create first gene1, then gene2, and so on.

[Pat]

walter can u tell wats the solution ,how to solve it please, if it not possible to create variables name its ok ,the output can be stores in any variable as i stated above,i need to perform that output ,please help

Answer 1

[Andrei Bobrov]

[~,~,c] = unique(A(2:end,1));
gene = cellfun(@(x,y)[A(1,:);x;A([false,y],:)],num2cell(B(2:end,:),2),num2cell(bsxfun(@lt,c,c'),2),'un',0);

OR

n = size(A,1);
gene = cell(n-1,1)
for jj = 1:n-1
    gene{jj} = [A(1,:);B(jj+1,:);A(jj+2:end,:)];
end