Forum Discussion

powerquerybabe's avatar
powerquerybabe
New Member
2 years ago

Grouping columns and rows issue

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> 

 

Need Help

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar
    2 years ago

    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.