Forum Discussion

ColinCowan's avatar
ColinCowan
Icon for Helper I rankHelper 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

 

 

 

 

 

 

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    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
      Icon for Helper I rankHelper I

      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