When column was set up as "Unique" and not as "Required" we allowed one blank value across all records; another blank value was considered duplicate. Now this restriction is relaxed – you can have multiple blank values in the table as we are checking only non-blanks for duplicates.