Filling the blank values in 50-50 ratio

[mycrytouno]

I am reading in an excel file which has some blank values for a column. I want to fill those blank values in such a way that 50 percent of them contain value A and 50 percent of them contain value B. How can I do that?

Eg: Suppose the particular column has 4 blank values, the output should be as follows.

Col1
A
A
B
B

[HansS]

Hi @mycrytouno and welcome to the Forum

Take a look at this workflow filling_blanks5050.knwf (27.0 KB) .

Hope this helps.

gr. Hans

[mycrytouno]

Thank you Hans. It worked perfectly.