Copying columns unique values to new column

I currently use this formula on google sheets: =UNIQUE(‘Sheet1’!N:N)

Is there a way to do this on glide so that I don’t have to wait for the data to refresh and can have everything in realtime?

Im a little bit confused. Im not looking for entirely unique rows. I just want to extract on the unique values from a singular column so that there arent any duplicate entrys in my list component

If you follow the steps in the post that Jeff linked to, you can use the resultant if-then-else column as a filter on your list. ie. only show records where the if-then-else column is not empty.