Removing blank rows to create list

I have two columns of data. The first is a list of companies, the second is a category, which may be blank. Example:

Company A - Category 1
Company B - Category 2
Company C - (blank)
Company D - Category 2

I want to create a new list that returns only on of the specified categories CONSECUTIVELY, ignoring blanks. So if I wanted only Company names with Category 2, I want the first cell in the new list to return "Company B" and the second to return "Company D", with NO row in between the two. Any way to do this WITHOUT a macro?

Thanks

Thanks, this is helpful, but I was hoping there was some way to do it in an automated fashion (i.e. a formula so I dotn have to use filtering)

Hi,

select the column which has blank cells.
Click GOTO. >> special >> select Blank
all the blank cells will be selected.
Click on any of teh blank ( selected ) cell.
opt for deleting the entire row..

Thanks
Shadmani

Awesome! thanks martin. Works great