How can I create this logic in the M language?

[matheus_peppers]

Guys, help me please.

How can I write this logic in M language in Power Query:

IF
In Column "Column1"

WHEN
contains any value below the line containing the string "FINAL BENEFICIARY"

THEN
returns the value below the line containing the string "FINAL BENEFICIARY" for the "BENEFICIARY" Column

[jbwtp]

Hi @matheus_peppers,

Can you produce a data sample and show what you are trying to achieve?

The description of the problem above is quite ambiguous. 

Thanks,

John