please help

[bao-bao]

Hi, all, I have a table like this:

tom 10
Mike 10
tom 20
jerry 30

Can you show me how to make a new table like this:

tom 30
mike 10
jerry 30

Thank you!

 

[Bob I]

Just as you did it here. If you want to do it programmatically, you
would need to use Excel spreadsheets instead, and write out all the cell
formula.