Problems merging sheets


This is the situation: I have two sheets in differents files (in Google Sheets). The first sheet has this columns:

IdGroup IdProduct Product Quantity

And the second sheet (in other file) has this columns:

IdProduct Product Quantity

The difference is only one column of the the first sheet (IdGroup). How can I join them with Sheetgo using a query?


Hi @SmartD,

Interesting challenge! :slightly_smiling_face::+1:

I would set it up as follows. Let me know if that works.