using a formula simlare to UNIQUE to create a list from a column of filled cells

I'm trying to figure out how to auto populate a list from a column with filled/empty cells. I know UNIQUE will populate a list, but sometimes the values are the same, and I need each cell with data t...