Spreadsheets get unique names but ignore blank cells

=unique(A2:A) should work

=unique(filter(A2:A,A2:A<>"")) to also ignore blanks

Yet another hack

=SORT(UNIQUE(A2:A))

Technically, this does not remove the blank result. But nonetheless puts it at the end of the list. You'll also benefit from the sort if you need it. 😁