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!
Additional question: should the sheet be in rows or records mode when sorting permanently , and then blank down?
I want to fetch data from reconciled values only per unique Q-Id
And when i got multiple values per Property I'd like to transpose these multiple values to columns per Q-id, again: in which mode am I supposed to do that?
Thanks in advance!
(i did manage once but seem to have lost the trick...
)