How to Merge Rows and Preserve Data in Clay or Python

·Jan 18, 2026 04:55 PM·

Is there a way to merge rows while preserving data? For example, i upload a list of companies with multiple physical locations and each location is its own row. Is there a way to create one company row and then fill the location data into multiple columns within that row? Would it better if i did this via python script before importing to clay?

5 comments

· Sorted by Oldest

Willy H.
·
·
Send data to one master table and then dedupe. You'll have all your tables preserved and then a table with all the data to do whatever with.
Willy H.
·
·
Curious what's the use case?
Sean W.
·
·
Importing companies with multiple physical locations to enrich for local rankings (and other enrichments) and then find people at company. Don't want to enrich each location as its own entity. The only enrichment i want to run for each location is the ranking tracker.
Sean W.
·
·
I don't want to dedupe them. I want to combine the location data under one row. I actually just did it locally using a python script before importing instead. Seemed simpler than trying to do it in clay
1
Willy H.
·
·
Congrats!
🙌1

Willy H.
·
·
Send data to one master table and then dedupe. You'll have all your tables preserved and then a table with all the data to do whatever with.
Willy H.
·
·
Curious what's the use case?
Sean W.
·
·
Importing companies with multiple physical locations to enrich for local rankings (and other enrichments) and then find people at company. Don't want to enrich each location as its own entity. The only enrichment i want to run for each location is the ranking tracker.
Sean W.
·
·
I don't want to dedupe them. I want to combine the location data under one row. I actually just did it locally using a python script before importing instead. Seemed simpler than trying to do it in clay
1
Willy H.
·
·
Congrats!
🙌1