Extract Values from a Table

I need help, have to extract a project billing hours from a very large table.

Rows contain employee names & columns are project name
What I need is , when I change the employee name, I need to extract how many hours for each project that employee has billed.
Since this is a very large table with more than 200 columns. Is there a formula where i can extract only columns with billed hours?
I'm attaching the sample sheet.

Thank you in advance

Is this for Excel 2016?

If you have 365, you can use this in C15:

=LET(f,FILTER(C8:N11,B8:B11=B16),VSTACK(FILTER(C7:N7,f<>0),FILTER(f,f<>0)))

I'm using office 365

Please update your forum profile and look again at post #2.

Here's a version with a drop-down selector and a conditionally formatted dynamic results grid.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.