If this column dont have this value, write this value

[terrellchong]

Hi team,

Would like to ask if I want to have this input and output, how can i write my logic?

[binuacs]

@terrellchong One way of doing this 

[Christina_H]

You need to do things in a slightly different order to make sure you get all 8 rows out