Pull unique values and no of occurances for particular column into seperate columns

We have a requirement like below.
e.g.
Consider a table with column as Names.
Names
abc
xyz
abc
pqr
pqr

We want two columns in another table as below.
UniqueNames NamesCount
abc 2
xyz 1
pqr 2

Is there any way to achieve this?

Hi,
Yes, that’s also a nice demo of link creating logic in airtables (link to existing record, and if not, create and link):

  • create new empty table2
  • in table1, add linked field to table2
  • copy-paste Names (whole column) to linked field
  • in table2, add count field to linked
    that’s all
    to perform cleanup, you could also:
  • (table2) convert count to text, delete records where linked field is empty,
  • (both) remove linked fields
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.