Extract disctinct values from a column of data

[Alex_L]

Having a problem with seemingly simple task:

1. extracting a single column of data from Airtable (no problem here)
2. Need to condense this column to only show only distinct values. AKA Excel’s “Remove Duplicates” function. or SQL’s “Select distinct”. Tried to follow instructions and links, but to no avail. Can some please show EXACTLY how to do that ? Many thanks !!

A slightly more complex problem would be to repeat this operation but not on asingle column of data but multiple columns. If you ca, please show that too , or instead

Many many thanks !!

[Mr.Make]

Hi,
The way I would do this is 3 steps.

1. Aggregate the column you want to into an array
2. Use function dedup on array - this will return unique array
   
   
3. Iterate the unique array so now you have your columns back into separate bundles (if needed to be done)
   
   

Best,
Mr. Make