Need help with excel spreadsheet

Attached is a spreadsheet showing what I want to do and I need to know the easiest way to do it. Any help would be greatly appreciated.