Rows should be removed which doesn't have any value

Hi folks anyone in the BIOVIA community help me out in the below scenario, how we can remove the row which has no value, so we can get only those data which has values using PLP.

In below output I need to remove middle row.

Only I need first and last row should be displayed except empty one or if it has empty value in any specific column, it should remove entire row.

Thanks