Power Query - Data enrichment ibased on existing information|Power Query|Excel Forum|My Online Training Hub

Hey

I want to complete missing information in some of the rows in my data table

The intention is to fill the empty cells in the Cannel column only if there is information for the value of Cannel in other rows
with the same "Source" + "C_Name"

If there is no unique information, leave it blank

Later I would like for cases where there is more than one option for Cannel to choose the option where "Amount_Spent" is the highest

I know how to do it easily in Excel and VB but I can't do it in the query

I would really appreciate for any help how to do this
Or where to look for an example of using query objects and functions and try to learn how to adapt it to my needs

Thanks in advance for any ideas or starting points on how to deal with this

I'm sure the solution is quite simple