How to Add Information in the Power Query Column by Comparing an ID Column
I downloaded this table to study and I have some doubts… In the “Enrolled” spreadsheet there is the ‘Name’ column where you can see male and female names, but in the “Complementary Information” spreadsheet there is the Gender column where the data came only as ‘Male’. I compared the id of the columns and they are all the same, but somehow the gender column didn’t come with the correct information… I was wondering what I should do to add the feminine gender based on the ID and name of the other sheet?[enter image description here](https://i.sstatic.net/HQ1UMEOy.png)