How to merge tables without duplication in columns

I am trying to create dashboard for report. For example, Table 1 is the table with the unique values Project Number and some basic details.

Table 1

Then I have the other table, with different sets of data, but the most important part will be, I'll need ALL the data for the pivot table

Table 2

However, when I try to merge them in power query, "Forecasted Value" will be duplicated and I will end up with a forecasted value for A1 to be 3000 instead of whats shown in table 1 due to the duplications.

Is there a way to merge (Group?) them or I'll have to create another table? Thanks in advance!