Custom editing in Power Query

Hi hakanbacak60.  Remove the column attitude.  Then select the Gender column and find Unpivot Other Columns in the ribbon.  That should get you where you want to be.  Hope this helps!

Hi hakanbacak60.  I'm reciting this from memory so it might not be perfect, but if you look a little bit, it might get you where you want to go.  Select columns Gender and Year.  Somewhere on the Ribbon is Transform > Group By.  Look for that.  Sum up the % column.  The downside of doing that is that it's going to remove individual percentages and you're stuck with aggregations which might finder further analysis.

I would suggest creating a DAX measure for this.  Could simply be SUM([%]) but hard to tell without knowing how you intend to use it.