UNIQUE that gives data without blank spaces.

=UNIQUE(FILTER(Raaw_data!E:E,Raaw_data!E:E<>""))

it will exclude all blank columns


and if you want to sort then just use sort

=sort(UNIQUE(FILTER(Raaw_data!E:E,Raaw_data!E:E<>"")))

it will arrange data alphabetically