Remove same Data from Multiple fields by Blank

[DataPirate26]

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.

[grazitti_sapna · Accepted solution]

Hi @DataPirate26, give this a try.

I hope this helps!

Thanks!

[binuacs · Accepted solution]

@DataPirate26 Another way of doing this