Merge into Single record - Power Query

[Anonymous]

Hi,

Hope someone can help me here.
How in power query I can achieve the below record as a single record.

i have approximately 20k records and many of them have below scenarios.. 2-3 records of per user ID's

I am after the below output.

Thank you

[HotChilli · Accepted solution]

Do a 'Group By' on the first 3 fields and add aggregations(MAX) for each of the other fields.

That should do it