Find and list all entries not equal to "-"

[Ijakor]

Hey,

Given a sample table (attached) I want to create a second table in which only entries not equal to "-" and any type of error are shown. Is there an easy way to get there?

I would be very thankful for your help.

[Ijakor]

Found the solution in a great youtube video: https://www.youtube.com/watch?v=cMchVJe7TDs.
Key was the use of Aggregate and Row- functions.