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

Ask for Help
1

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:

image
image1310×640 54.7 KB

Is this possible?

Thanks!

2

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:

image
image1600×1280 133 KB

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