Linked columns in different table

[Andy_Springer]

Hi,
I’ve created an Airtable with 3 different tables.
-1 table for survey 1
-1 table for survey 2
-1 table to summarise both surveys

In my “summary” table I need to get data from 1 column in survey 1 and from 1 column in survey 2. I’ve tried lookup and link record but couldn’t manage to do it.

The surveys tables are made of copy/paste data from CSV files that I update when i need by doing more copy/paste.
Columns name and order in both surveys table are different.

Do you have any ideas on how I can manage this?

Many thanks for your help1

[Andy_Springer]

thanks for the explanations :slightly_smiling_face: I think we’re getting there.
My only problem now is that I need to get 1 data per row, not everything in the same cell.

[Andy_Springer]

I’ve found the way to do it!
Thanks for your help all the way! really appreciate it