Bridge Table - Create new table from two columns in different tables

I have two tables and I would like to create a new table based on two columns. one column from each table.

For instance, Table 1 has Contact ID column and Table 2 has BC # column. I would like to make Table 3 that has Contact ID and BC column in one table.

I cannot use merge because these table do not have a relationship with each other. I am trying to create a bridge table for data modeling relationship purpose