how to fill missing values with a specific set on string values

Question

This is my DB,

its got too many missing cases for me to do it manually, and I can not use flash fill in this case, so I want to randomlly fill these case with a specific set of strings :"TCS", "TCLSH","TCEO", and "TCT" how can I do it in excell please help and thanks a lot in advance

Answer 1

You can do this in a separate column using index with randbetween (per screenshot / this sheet) as follows:

=IF(B3="",INDEX($H$3:$H$6,RANDBETWEEN(1,COUNTA($H$3:$H$6))),B3)