Power Query - Data enrichment ibased on existing information

Hey

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

For example i want to add information to the empty channel field according to the information that exists in the data in other rows
In this example for source=Src_O and C_Name=C_nm4 there is a value for Channel in some of the rows (Cnl_3) PQ1.png

I'm sure it should be simple and the logic is clear just can't seem to implement it

Thanks in advance

Thanks

I hope I correctly defined the desired result

The goal is to complete empty values in the Channel field if the information exist for the same source and also for the same C_Name

For example for source=Src_T and C_Name=C_nm2 the empty rows should have the value Cnl_3

additional help that I didn't ask before
How do I change the value of source for rows where C_Name contains a certain string?
For example, any C_Name that contains "nmNew", the corresponding source will change to Src_G no matter what the original value was

Thanks in advance

Sorry again, maybe I didn't clarify correctly, but it is required to complete the values in the empty cells in Channel according to the 2 fields - source and C_Name together

For example, the empty values when source=Src_O and C_Name=C_nm5 should be Cnl_1 and not Cnl_3 as in the solution you proposed

I would also appreciate additional help that I didn't ask before
How do I change the value of source for rows where C_Name contains a certain string?
For example, any C_Name that contains "nmNew", the corresponding source will change to Src_G no matter what the original value was

Thanks in advance

Hey

Trying my luck again

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

Thanks for bringing it to my attention
I posted the same question on 2 other forums

I got an answer in this forum:
https://forum.enterprisedna.co/t/pow...mation/59306/7

Thank you