sort data into a different column using a formula and putting blanks at the bottom

I am trying to sort my data from two columns, into two additional columns. This has to be automated without a macro or manual sort or filter. I have attached an example of what I am trying to do. the data needs to be pulled into the new column based on Column B, and would like to have it then sorted based on column A (but that's not as important as getting only the data that has data and doesn't contain a zero in Column B to show first) , ignoring the blanks or keeping them under the data. I am on Excel 2007.

Any help would be greatly appreciated.

Thanks,
Hollie

Hengland, good time of day.

Take a look at the attachment. Spool column holds single cell Array Formula (Ctrl + Shift + Enter against usual Enter), that must be prolonged manually to a bottom of the table. Second column - just simple VLOOKUP.

Formula:

Please Login or Register  to view this content.

Best wishes.

Thank you Rioran!! That worked perfectly!!!!!