Custom sort based on another value that has contain many blanks

[Marcky]

Hi there

would like to seek your help to geting sort the visual with these data

This is the visual that i want to sort based on the value of MCI

This is the reference data

Senior_VP	MCI Count
Aaron	1
Amanda
Balaji
Christine
Christopher 1
Christopher 2
Duane
Gregg
James	9
Jennifer 1
Jennifer 2
Jordan
Joshua
Juliette
Maria	1
Mike
Muhammad
Ramiya	3
Sharon
Srikanth
Susan
Trung
Usman
Vivek

i hope you can help me with this

[lbendlin]

replace the blanks with an appropriate value (for example 0 ). Add a small random number to break ties.