I have this table in Google sheet:
|Col A (Month)||Col B (Date)|
And I have another table:
|Col C (Dept.)||Col D (KPI)|
I want to repeat the first table for each item from the second table to be like:
|Col E (Month)||Col F (Date)||Col G (Dept.)||Col H (KPI)|
I tried to work with query inside an array formula but it is not working.