I'm generating a list based on using the
How can I get the output to be alphabetized automatically?
Use Sort and Unique together.
Here are the descriptions of the filter functions for Google spreadsheets.
I add a filter function to keep only cells with data.
Maybe it could help.