Return a list(with no spaces) of values based on a condition

[spreadsheets]

I am trying to generate a list of components that are on at least one part(Par 1, Part 2, Part 3, etc) but I want to exclude the components that are not any part. I generated this list in A11:A15. The formula I used was =IF(SUM(B3:G3)=0,"",A3)


-- removed inline image ---


That formula gives me A,C,E which is correct but to create a clean report I would like to run a formula that gives me that same list without the spaces. I know it has something to do with the following construction formulas but I haven't been able to figure out how to combine them. ((Index)Small(IF(Row)),Row)

Thanks ahead for your help.


-- removed inline image ---

 

[spreadsheets]

This picture is supposed to be included in my post.