I hope it is not duplicated enquiry. I searched and tried for one week but in vain.
Please refer to my google sheet in this link.
https://docs.google.com/spreadsheets/d/1cuNkoR4Rn7Lt0u-aCB4487JnucMKYgx0ETn6R_w7-ds/edit?usp=sharing

I want to query the original data, using the combination of two values in column 1 of original data. The combination is calculated using the cruestian product. For every combination queried, a sepeartor row is inserted and so on. The anticipated outcome is shown in expected data.

I tried using lambda and query (shown in cell M3). I also tried using filter and index, all of which appear did not accept the array value as input.

The issue is stuck for weeks. I seek your professional input and advice. Thanks.