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

Hi all,

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

Solved.

Utilized this website to create a bridge table.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive