Replace all the empty rows in the column with the value that you have identified
By Ross Reinger at Nov 18 2020