Remove same Data from Multiple fields by Blank

Question

Hello,

Can someone help me to achieve the Output that is in the table below from the input which is the table above. I want to remove the entries that are same with blank in multiple fields. Just the Subtotal row will be there.

Remove same data by blank.PNG

grazitti_sapna · Accepted Answer

Hi @DataPirate26, give this a try.

I hope this helps!

Thanks!

binu_acs · Accepted Answer

@DataPirate26 Another way of doing this