MATLAB: Merging cells,adding contents

add cellsduplicatesmergeunique

Hey everyone.! I have some data in this form
    'Mary'    [ 37]
    'Lisa'    [ 18]
    'George'  [ 20]
    'Nick'    [ 49]
    'Mary'    [ 24]
    'George'  [  4]
    'Lisa'    [ 36]
(random names with random sequence)and I want to have this
    'Mary'    [ 61]
    'Lisa'    [ 54]
    'George'  [ 24]
    'Nick'    [ 49]
(not necessarily in this order) Any good ideas? Thank you all..

Best Answer

v={'Mary'    [ 37]
  'Lisa'    [ 18]
  'George'  [ 20]
  'Nick'    [ 49]
  'Mary'    [ 24]
  'George'  [  4]
  'Lisa'    [ 36]}
[a,b,c]=unique(v(:,1),'stable')
n=accumarray(c,[v{:,2}]')
out=[a num2cell(n)]
Related Question