Forum Discussion

ColinCowan's avatar
ColinCowan
Helper I
3 years ago
Solved

Consolidate Data Power Query

Hi, need some help with the next step see below example of the desired outcome from the result from power query

 

 

 

 

 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    ColinCowan Could be wrong, but seems like you want to do a Group By essentially. It's an icon on the Home tabe in the Transform section.

    • ColinCowan's avatar
      ColinCowan
      Helper I
      3 years ago

      Hi, had a try unable to get the data to consolidate and sum

      1ST TABLE

      05/11/2022 Willnga Rufio 2.0

      05/11/2022 Willnga Rufio 1.5

      RESULT REQUIRED being the addition of the above:

      05/11/2022 Willnga Rufio 3.5