Forum Discussion

tebtim19's avatar
tebtim19
Icon for Helper IV rankHelper IV
4 years ago

Merging Data

Hi can anyone help me with merging data   I have 2 table which I neeed to merge, but I dont have any relationship to this table   the reason why I need to merge is, I want to combined the values ...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
4 years ago

Hi tebtim19 

Go to Power Query
In table1 and rename the column, "Type" as "Categoty" and "Average" as "AVG"
In table2 and rename the column, "TypeCategory" as "Categoty"

Go to Append or Append as New and marge the data

 

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos