Extract all unique data from a column

Is it possible to extract all the unique data from a column? For example, one column is containing last names. I would like to generate a list of all unique last name stored in that column.

@ampotvin When you perform a text facet on your column with names, you get all the values on the left.

If you then click on the number of choices (for example: 19 choices), you get the values and number of occurrences as tab-separated text:

Is this what you need?

1 Like

Another method is when you need the data in your sheet:

  • sort bij last name
  • make sorting permanent
  • create extra column based on last name, called 'unique last name'
  • choose cell modifications 'blank down'
  • you now have a column with every last name only once. You can use a facet 'filter by blank/null'
1 Like

Yes, that is what I was looking for. Thank you!