Consolidate Data Power Query

[ColinCowan]

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

[Greg_Deckler]

@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]

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

[ColinCowan · Accepted solution]

Hi will give it try thanks