Assigning values to first 4 values of excel empty row

I’ve some requirement where i need to assign value from one table to another table based on weighted scenario . I was able to get value of that weight as number . Now im kind of stucked how i can assign only first non empty rows as a value.

User Codes Adescription weight W_Value
ESTRADTG 1 Missing Assets 50 4
PADINC 1 Missing Assets 50 4

For instance in this example W_ value is 4 for first 4 non empty rows.
Let me know what you think about it

@apurvalost
So is it based on “Weight” and “W_value” you want to assign value to another (new ) table

@elina W_Value