I have a few worksheets that pull data from another worksheet. In the
third column of the main data is a number from 0 to 5, with many 0's.
What I want to do is run a formula or code on the results page where if
the number from column 3 is greater than 0, it pastes the matching text
from column A on the data sheet into the results sheet without any
spaces. For instance:

Data sheet (example)
Happy 4000 0
Sad 5000 1
Tired 6000 0
Angry 2000 2

What I get on the results page when I run an If formula is

(blank cell)
Sad
(blank cell)
Angry

What formula would I use to make it automatically put angry right under
sad with no blank spaces on the results page? ie...if no match found,
it runs the formula again until match is found

Any help you can give would be greatly appreciated. Thanks