This can be done while loading data. please find the below steps for the same
Step 1: In load script, load excel file. "Table Files..." -> Select the file and click next
Step 2: Click on "Enable Transformation Step"
Step 3: select "Fill" option., select the option according to your requirement and click ok
Step 4: Click next and finish