In google sheet, I have a data set A:
In another sheet I am creating a dynamic list using the UNIQUE formula:
However, when I use filters to sort the data, it gets all scattered leaving empty cells where there shouldn't be any:
Does anyone know a workaround to avoid this? Is it impossible to use filters AND Unique at the same time or is there another way to do this?