Consolidate rows by skipping zero values

Hello
I'm an intermediate user and can usually google my way to a solution but this one has me stumped.
I want to pull data into a spreadsheet that will be imported directly into software. Rows with $0 will create an error with the import. So what I'm looking to do is return values from an array only if the $ cell is >0. If it's not >0, I want it to move to the next row and so on until it finds a row with a $ value >0.

For example, this table -

table.PNG

Would be consolidated to this -

import.PNG

The code, hours, and value are returned, but only for rows where the value >0, and there are no blank rows in the import.

Thank you for your time!

ETA: Using MS Office professional plus 2019

this would be one way... in F4 copied down until returns blank =IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$8>0,ROW($B$4:$B$8)),ROWS($B$4:B4))),"")
expand the range in col B as necessary.
Then in col G this ... =IFERROR(INDEX(C:C,SMALL(IF($B$4:$B$8>0,ROW($B$4:$B$8)),ROWS($B$4:B4))),"")

I completely missed the middle with my formula, so here would be my version =IFERROR(INDEX(B:B,SMALL(IF($B$4:$B$8>0,ROW($B$4:$B$8)),ROWS($B$4:B4))),"")

Thanks Gregb for the alternative, it prompted me to realize that I missed the middle column. You know now that I have the newer version of excel I should think about some of the newer formulas more often like FILTER.

sorry your attachment is coming up as invalid. In some (maybe non office 365) versions of excel these formulas could be array formulas so have you tried to use it as an array? It isn't in my version but it could be in yours? Or try to upload the workbook again using the instructions at the top of the post.

Great, glad you got it working. AND thank you for the rep!