Power Query lets you perform a series of steps to transform your Excel data. It allows you to take is to fill data down easily. Click here to learn how.