Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Combining data from

Hi,   I want to combine two tables by including all values. Below I represented it with sample data on how I want to have the table.   Table1: Date Unit Subunit Value1 05.2021 A A1 1...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    5 years ago

    After doing NidhiBhusari solution you can use group by in Power Query Editor to give you desired result. As it will combine the same row and SUM all the values in Value1, Value2

     

     

     

NidhiBhusari's avatar
NidhiBhusari
Icon for Helper IV rankHelper IV
5 years ago

Hi IF ,

Try using append in Power query editor.

 

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    I tried that one but the table is not really the one I am looking for. If there is a value for matching data, I want to show them in the same row. For example, Unit:B, Date:06.2021 and Subunit:B2 is repeated value. How can I show them in the same row?

    • FarhanAhmed's avatar
      FarhanAhmed
      Icon for Community Champion rankCommunity Champion
      5 years ago

      After doing NidhiBhusari solution you can use group by in Power Query Editor to give you desired result. As it will combine the same row and SUM all the values in Value1, Value2