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?
2 Likes
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'
2 Likes
Yes, that is what I was looking for. Thank you!