How I do

[Clayton Santos Delfino]

Hi friends.

My name is Clayton, from Brazil and this is my first message.
Ohh... my english is not very good then have patience with me.

Sorry but i need you and is not because exist a problem with a program.

If you can help then thank you very much if not, thank you too. ;-)

I have a data list with 300 records, two colums locate and energy

Example

locate  energy
1       900
2       203
1       300
3       12
4       232
5       304
4       400
5       677
....    ...
 
The values possibles to locate are: 1 until 5.

How i do a table like this:

Locate  Sum enegy power 
1       1200    
2       203     
3       12      
4       632     
5       981     
                

Thank you.

Clayton