Merging multiple rows with into one with name logic

[shap]

Hi,

I have 5 columns that have a company name in them, then the rows have '1' or blank if an order went to that company. I'm looking to simplify this by adding a row that says 'Vendor Name' then each row will display the name based on the other rows '1's or blanks.

Example:

What's the easiest way to do this?

Thanks!

 

[W8253]

In H3:

=IF(A3=1,$A$2,IF(B3=1,$B$2,IF(C3=1,$C$2,IF(D3=1,$D$2,IF(E3=1,$E$2,IF(F3=1,$F$2,IF(G3=1,$G$2)))))))

 

[shap]

Thank you! Added to our file with a lot more IF's and worked great.