How to update particular row data from different row value.

[anonymous008_G]

Hi -  How do I Bond Futures row for Short and Long column with respective Short and Long data from sector column. The Order keeps changes, so i need something which would work even if order changes. 

Sector	Gross	Net	Short	Long
Bond Futures	100	200
Short	50	80	30
Long	70	90		20

Expected Output :-

Sector	Gross	Net	Short	Long
Bond Futures	100	200	30	20
Short	50	80	30
Long	70	90		20

[anonymous008_G]

@OTrieger & @binuacs - Thanks both of you for your help. I am taking @OTrieger's solution since it would work in all three cases if any month Long or Short missing. Thanks again. I appreciate all the help and time.