Hi everyone,
Here is my question:
I have two columns "Name", and "Gender". There are duplicate names, for some, the value for gender is specified, but for some, the value is missing.
The goal is to identify the missing ones based on other occurrences of the same name where the gender value is available.
Marcelo Branco provided the solution in Excel, which is very appreciated (Excel solution)
I am curious to know if it is possible with power query during the transformation phase.
The screenshot for better clarification.
Here is my question:
I have two columns "Name", and "Gender". There are duplicate names, for some, the value for gender is specified, but for some, the value is missing.
The goal is to identify the missing ones based on other occurrences of the same name where the gender value is available.
Marcelo Branco provided the solution in Excel, which is very appreciated (Excel solution)
I am curious to know if it is possible with power query during the transformation phase.
The screenshot for better clarification.