Try this, it should work.
once you get 1 or 0 in columns B, don't use filter,just copy the entire column B or only cells filled with 1 or 0s.Then use Paste Special->Value to remove the formulas .
Now select column A and B, then use Sort on column B. Then you can delete cells in column A and B where the number in column B is 0.
This way you don't need to delete the entire rows and save your data in other columns.