Combining data on list containing blank lines

I work at a wound care clinic and have been asked to create a form.

Clinicians will click Option Buttons to choose the wound care supplies they used for a treatment (one button for one particular treatment supply). These are in descending order. So a list might look like (each supply on an individual excel row):

Allevyn Foam
Aquacel AG

Hydrogel Sheet


Regranex

The blank lines represent supplies that were not selected. Is there a way I can list these chosen items sequentially (somewhere else on the worksheet) without the blank rows so it looks like:

Allevyn Foam
Aquacel AG
Hydrogel Sheet
Regranex

Any help would be appreciated!

Thanks,
I've attached (hopefully!) a copy of what I am referring to.

Thanks for any help.