formula to generate a separate list of only products ordered

I need a formula to generate a separate list of only products that have been ordered.

Column A has a list of all availableitems; apples, oranges, pears, etc.
Column B has the number of each ordered. Some have numbers, some are not ordered and are 0.

I need a list in Columns C and D that shows only items that have been ordered, non-zero entries.

See my example sheet

Many Thanks!

Rod

Cell A13 formula

Formula:

Please Login or Register  to view this content.

Many Thanks! Simple and elegant.

On my sheet I got a spill error. Let me work on it

R

That did it. I cleared the cells and all the data populated correctly.

Thanks again.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the text PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I went to the first post, but thread tools didn't have PREFIX on the upper left,to select [SOLVED]