List of values within a range

Tried searching on "List" but haven't found an answer to this query. Doesn't really seem to overlap the LIST function.

Have records with non-consecutive numerical designations in one column. The numercial designations repeat so that for 10,000 records there might be 7 or 8 values reflected in that column. I can scroll through and jot down the 7 or 8 but is there a function that can query a range and return a comma separated list or a table of the distinct values in that range.

So if the column looked like this:

8
8
8
8
11
11
11
11

the function would return 8,11.

Thanks,

Brian