Can this be done...?
 

Hi,
I have an address list that has multiple contacts for each business in the
list. I need a separate list with just one line for each company. It is
sorted alphabetically by company name. Is there a formula that will give me
the entire row every time there is a change in company name?

Thanks.