Hi Neil,
You have to select all populaed cells (exclude the heading column).

Then select Data > Sort check Ascending
Select Weight column from the drop down
select OK