Dynamically create a new table using values from 2 other tables.

[lfk32]

I have 2 tables being imported on a schedule into PowerBi.  These two columns have a commn field that i use to link them.  I want to create a new table using data from these 2 tables and have this new table auto update each time new data is imported into the 2 original tables.

Im a bit of a noob so i need an easy explanatio nhow to ahieve this.  Thanks.

[lfk32]

Ok figured it out.  Simple merge as it turns out