How to remove items from list

Hi Team,

I have an excel master file which contains two sections in one sheet.Need to filter out valid email addresses under column A which contains blanks and header value of section 2. How to achieve this?

Can you post a sample of the data