Forum Discussion
jovian1511
Aug 20, 2023Copper Contributor
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 dif...
Detlef_Lewin
Aug 20, 2023Silver Contributor
I think you have to unpivot the columns "Forecast value" and "Amount received".
That will remove the orignal columns and create two new columns "Forecast/Received" and "Value".
Then you can merge the tables and create the pivot table.