Formula for pulling values from one sheet to another ignoring the non zero values

I am trying to use a formula where I can pull only non zero values from Sheet1 to Sheet2.

My Sheet1 looks something like below
A B
1 x 4
2 y 5
3 6
4 a 7
5 b 8
6 c 9

Expected result in Sheet2
A B
1 x 4
2 y 5
3 a 7
4 b 8
5 c 9

Thanks

Originally Posted by Jakobshavn

Set up an AutoFilter on the Sheet1 table. In the column B pull-down, clear the (Blanks) checkbox. Copy the table and paste in Sheet2.

Thanks for the reply. But I dont want to do it manually. I want a formula which will pull values from the Sheet1.

Thanks