MATLAB: Finding the number of occurences

matrix

I have values as
gene =
          {6x5 cell}
          {6x5 cell}
          {5x4 cell}
          {4x5 cell}
          {3x5 cell}
          {2x4 cell}
It consists of values as 
gene{1,1}
'Genes'   'T0&T2'  'T2&T4'  'T4&T6'  'perc'
'YAR029W'  'd'  'd'  'd'  60
'YAR062W'  'du'  'ud'  'du'  60
'YBL095W'  'du'  'ud'  'du'  60
'YBR074W'  'du'  'ud'  'du'  60
'YBR138C'  'du'  'ud'  'du'  60
'YBR285W'  'du'  'ud'  'du'  60
I need as 
'Genes'        'T0&T2'  ''   'perc'
'YAR029W'  'd'     ''  60
'YAR062W'  'du'  3  60
'YBL095W'  'du'  3  60
'YBR074W'  'du'  3  60
'YBR138C'  'du'  3  60
'YBR285W'  'du'  3  60
3 is the number of occurences it varies for other genes,please help

Best Answer

r = cell(size(gene))
for jj  = 1:numel(r)
    r{jj}(:,[1:2,4]) = gene{jj}(:,[1:2,end]);
    r{jj}(:,3) = [repmat({''},2,1);repmat({3},size(r{jj},1)-2,1)];
end
Related Question