Grouping columns and rows issue

[powerquerybabe]

I am trying to group two columns Portfolio and Grouping into two  new columns removing the null from rows - please can you help wiht the best option to do this> 

[olgad]

Hi, Group by and take the MIN of all the columns. Bu the question is whether you have in your data two rows with the same portfolio and all the values filled? then you would need to tweak it further.