Hide blank rows for Collapse total in table chart

I am using collapse total feature in table chart. I have made ‘collapse total’ ON for second column and OFF for rest. So as shown in attached screenshot I don’t want to see BLANK rows.

Is there any way to hide those?