From the initial responses I am guessing that this can only be accomplished through a fair amount of VBA, but here is a simple example of what I want.
Rather than the following...Field A: Data
Field B: <Blank>
Field C: <Blank>
Field D: Data
I want...Field A:Data
Field D:Data
Though, of course, any or all of the fields (and there are more than four) may be blank. FYI, none of these fields can be edited, but I doubt that matters.
I used the word paragraph to indicate that the entire line should be removed.