Two quaries have different data set but in one row some data is common, I need the complete data from both the queries

Question

I am trying through Power query but could not do it so far

I have two data sets

Table-1 it contains vehicle movement on particular dates

and Table-2 it contains check points between two zipcodes

now zip code is given in the first table as well. so that is the common column, next what i need is data by checkpoint name:

Result

Please help, thanks in advance

Answer 1

It's easy enough to do in a macro.

1. Loop through table 1
   1. Loop through table 2 till zip codes match
   2. Add record to output table for the checkpoint/car combination
      1. Go to next row in table 2
      2. If no zip code in row, go to step 1b
   3. Next table 1 row
2. Sort output table by checkpoint and date (and maybe by car).