Organizing Company Tables: Grouping Accounts with Multiple Identifiers

Willy H. · 2025-12-18T22:48:05.968Z

Company Table Organization: Grouping same businesses after enrichments? I'm helping a Clay customer and my client with list building. Could someone help me think through the organization of accounts when we have multiple unique identifiers in a table? Here's a video:

Organizing Company Tables: Grouping Accounts with Multiple Identifiers | Clay

Clay Support
APP
·
·
For organizing companies with multiple identifiers, try these approaches:
Dedupe by company name: Click the column header → select "Dedupe" to remove exact duplicates. [1]
Normalize company names first: Use Tools → "Normalize Company Names" to clean up variations like "Inc." or legal suffixes before deduping. [2]
Send organized data to new table: Use Actions → "Send table data" to move cleaned records to a fresh table with better structure. [3]
Map lists to separate rows: If you have multiple contacts per company, use "Write to Other Table" to map each contact to individual rows in a new table. [4]
Since I can't see your video, try Sculptor (top-right corner) - it can help build the exact table structure you need for your specific case. Let me know if Sculptor helps or if you need more specific guidance!
Clay Support
APP
·
·
Is that what you were looking for?
Willy H.
·
·
yeah! but I don't want to delete the entries just identify that they are with the same clinic/practice...
Clay Support
APP
·
·
Perfect! Instead of deduping, add a column to group/identify related entries:
Add Column → Merge columns to create a "Clinic/Practice ID" column that combines identifying fields (like normalized company name + location). [1]
Or use Actions → Send table data to create a separate reference table with unique clinic/practice identifiers, then link back to your main table. [2]
This way you keep all entries but can easily filter or identify which ones belong to the same clinic/practice. [3]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with grouping related entries without deleting them, I’m here to assist. Would you like to provide more details about what you’re trying to achieve with the organization of your company table?
Willy H.
·
·
could I get a human to help?
Clay Support
APP
·
·
I understand you'd like to speak with a human agent, so I’m routing you to our team now for further assistance.
Willy H.
·
·
thank you!
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

image.png(93 kB)
Willy H.
·
·
https://app.clay.com/workspaces/609658/workbooks/wb_0t7hcvccUCTA3M84t4g/tables/t_0t7hcvckyNevAurojcW/views/gv_0t7hcvcfPNdTg7aruvN
Sayli G.
·
·
Hey! Thanks for waiting patiently while I figured this out. Created a loom for you outlining my thought process and recommended solution. Do let me know if I have misunderstood or if there is anything else that I can help you with! :)
Willy H.
·
·
Sayli G. watching 😄
Sayli G.
·
·
No problem, its a little long haha. Take your time!
Willy H.
·
·
this is the Engineering part of GTM[E] 🙂 you're doing an amazing job!

36 comments