Combining 2 separate columns of Table1 & Table2 into a column in Table3

Hi,

I want to combine 2 separate columns of Table1 & Table2 into a column in Table3. Below I prepared an example scenario in Google Sheets:

Is this possible?

Thanks!

I solved this problem and here I am sharing if anybody else wants to do the same thing below.

This is the data structure and table design:

Here is the formula as a text for convenience:

list = (Table1.lookupRecords().categoryID + Table2.lookupRecords().categoryID);
if($id-1 < len(list)):
  return list[$id-1]
else:
  return ""

You need to adjust Table1,Table2,Table3 and vehicleID for your cases of course.

Hope that helps somebody like me :slight_smile:
You can ask me on Twitter if you are stuck, I can try to help: https://x.com/_burakkurkcu

1 Like