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

[Shashank_Ambeka]

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?

[Alexey_Gusev · Accepted solution]

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