I have a column that looks something like this:
[4,5,6,4,4,4,4,5,6,7]
I want to return the distinct values in a table column like this:
[4,5,6,7]
The problem is if i add an 8 to the first column:
[4,5,6,4,4,4,4,5,6,8]
Then I needed it to return: [4,5,6,7,8]
I need the table to expand. In other words, it needs to update by itself.
I tried using Data --> Advanced. But is does not expand the table and needs to be updated manually.
Any tips?
Thanks for the help!