Summarizing Data by removing zeroed values

[Coxy347]

Hi,
I am constructing a portfolio management system in excel the aid management in my job.
Currently i have now is a large security database that updates dynamically based on a transaction history and date selected.
The problem i have is that the security database is not what i want to present to the user, as there are many securities here with positions of zero.
I want to be able to produce the table with identical headers, but remove the securities with a zero value on another sheet.
I have attached an example of what im looking for here, if anyone could help on a way to automate this it would be great.
Data clean up example.xlsx
Thanks

[AlKey]

Array formula in B4 and pull formula down and then across

=IFERROR(INDEX('Raw Data'!B:B,SMALL(IF('Raw Data'!$D$4:$D$10>0,ROW('Raw Data'!$D$4:$D$10)),ROWS(D$4:D4))),"")

***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER

[Coxy347]

Absolutely perfect.
Thankyou so much