We need to do this all the time, but as far as I know there is no simple way of doing it in InDesign.
"Remove blank lines" does just that, but does not deal with an empty field on the same line as another, non-empty, field.
Best to fix it in Excel. Create a new column and use the formula...