Skip to main content
Solved

I have two different tables with organizations that each have linkages already. How can I combine them?

  • July 11, 2025
  • 3 replies
  • 89 views

Forum|alt.badge.img+4

They are in the same base.

Best answer by TheTimeSavingCo

Assuming you want to consolidate two tables into one, you could try:

  1. Pick one table to delete, and for that table export all of its data as a CSV
  2. Use the CSV Import extension to import all the data into the table you want to keep
  3. Delete the old table
This topic has been closed for replies.

3 replies

Mike_AutomaticN
Forum|alt.badge.img+28

Hey ​@Judy12 what do you mean combine them? Would you mind sharing a couple of screenshots of your setup?

If by combining you mean to actually link the records together, you can do so by clicking on the + sign within a cell of a linked record field. Then you’ll be able to choose any record(s) from the linked table.

Mike, Consultant @ Automatic Nation


Taha-Jiruwala
Forum|alt.badge.img+9

I'm not sure what you mean by "combining." If you mean showing all the fields from both tables in a single table, then what you're looking for is the lookup field.

Taha, Airtable Advisor


TheTimeSavingCo
Forum|alt.badge.img+31

Assuming you want to consolidate two tables into one, you could try:

  1. Pick one table to delete, and for that table export all of its data as a CSV
  2. Use the CSV Import extension to import all the data into the table you want to keep
  3. Delete the old table