Fill empty cells with the same column distribution

roeebicher

Hi,

I want to fill a column with missing values so it won't change the distribution of the columns.

for example, if the column have 60 non-empty records and 18 empty records, for exampel:

10 records of A (17% of non-empty)

20 records of value B (33% of non-empty)

30 records of value C (50% of non-empty)

and 18 empty records

then I would like to fill the values A in 3 records (17% of empty), B in 6 records (33%) and C in 9 records (50%).

Any suggestions how can it be done?

---

Operating system used: Windows